Forum Discussion

mrothschild's avatar
mrothschild
Continued Contributor
6 years ago
Solved

Cluster Column Chart - sorting by dates

In the screenshot below, you will see that the x-axis is not sorting correctly.  When I drill up in the hierarchy, the quarters and years sort correctly.  Even if I add "Date" to the Axis hierarchy t...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    mrothschild you have to month sort column in your model and sort you month wiht this month sort on modelling tab.

     

    So add another column called Month Number which will be 1 for Jan, 2 for Feb and so on.

     

    Selected Month column, go to modelling tab under sort by column, in drop down, select month number column. Basically you are telling model that you want to sort Month column by Month Number otherwise your Month column is sorted alphabetically which doesn't make sense in case of Month

parry2k's avatar
parry2k
Super User
6 years ago

mrothschild you have to month sort column in your model and sort you month wiht this month sort on modelling tab.

 

So add another column called Month Number which will be 1 for Jan, 2 for Feb and so on.

 

Selected Month column, go to modelling tab under sort by column, in drop down, select month number column. Basically you are telling model that you want to sort Month column by Month Number otherwise your Month column is sorted alphabetically which doesn't make sense in case of Month

  • mrothschild's avatar
    mrothschild
    Continued Contributor
    6 years ago

    Thanks, that did the trick!