How to Arrange Data in Chronological Order in Helical Insight 3.0?

General
, ,
#1

Hi Helical Team,

I am having a report with timestamp in Helical Insight 3.0. Via db function I have extract Month name and I would like to create a report wherein the data is arranged in chronological order. Now when I am clicking to arrange by ordering it is only arranging the data in alphabetical order and not chronological order.

image

#2

Hello Anu,

In the created report drag one more column which is timestamp/date time stamp. Now the tabular report will look something like below.
image

Now on this first column, via DB function, extract the monthnumber.

Now click on this first column (which is date stamp/date time stamp) and arrange according to this column. The data will now be arranged in chronological order and appear like below.
image

Now in case if you would not like to include the first column in the report, you can go to “Editor” and insert the below-mentioned code in CSS. This will delete that column from the frontend even though it will still continue to be arranged according to that.

th:nth-child(1), td:nth-child(1) {
  display: none;
}

Note: For the solution to work this should be the date/date time column should be the first column.
image

Thank You,
Helical Team.

1 Like