Incorrect Month Sorting

[Random_1191]

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.

[Wadeyy03]

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 :

[Spd_03]

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.

[Wadeyy03 · Accepted solution]

 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.

[Random_1191]

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