topic Re: Incorrect Month Sorting in Dashboards & Analytics Discussions

Incorrect Month Sorting

Random_1191 — Mon, 17 Apr 2023 16:22:43 GMT

Hi there Community,

I'm just starting my adventure with Incorta, so first problem appear, thats Why Im asking for help.

I have a problem with the proper sorting of months, from what I can see they are sorted alphabetically, and I would like them to be shown according to their occurrence.

*In the table, the data I have are the names of the months:

Many thx for help.

Re: Incorrect Month Sorting

Wadeyy03 — Tue, 18 Apr 2023 09:22:55 GMT

Hi ,

You can do the following task by adding the date column associated to the table to the sort by condition in the months column in the group dimension :

Re: Incorrect Month Sorting

Spd_03 — Tue, 18 Apr 2023 12:15:10 GMT

Hi,

If you've a date column in your data set, convert the date into month using Month() function by creating a formula column

Formula : Month(Date_Column)

Now this will create a Month Column as Integer and you can add this formula column into your grouping dimension under sort by.

Re: Incorrect Month Sorting

Wadeyy03 — Tue, 18 Apr 2023 12:58:32 GMT

True ,but with the parameters you had given this was suitable(assuming you had access to a date column and wanted to keep the months column) otherwise there is another solution for this :

I believe this is the response you were looking for?

Without the date column being available to the user.

Re: Incorrect Month Sorting

Random_1191 — Wed, 19 Apr 2023 05:01:04 GMT

I dont have any date column I could convert so thx @Wadeyy03 thats the solution I was searching.

Re: Incorrect Month Sorting

anurag — Mon, 26 Jun 2023 20:14:39 GMT

We have added new features in the product where we have simplified sorting by month name.

Please review this video to see how easy it is to sort month name correctly:

https://youtu.be/cgmbVtrYpJo