Forum Discussion

jbrines's avatar
jbrines
Icon for Advocate III rankAdvocate III
8 months ago
Solved

Changing Chart to Calendar month order

Hi All,   Thanks to BeaBF I have a great report for my helpdesk statisticts, I just need it to display charts in a calendar month order, as you will see below it is doing it in a strange order.   ...
Need Help
Show and Tell
  • MasonMA's avatar
    MasonMA
    8 months ago

    Hi, 

     

    As other users mentioned, the ideal way would be to add a 'Month Number' column in your table and then Sort your Closed Date column by Month Number. This way Month Name Column in your visual will be sorted by Month number instead of the alphabetical way. 

     

    Alternatively, since you've enabled 'Auto Date/time' in Option, you can also Drill up and then Expand all down one level, it will also give you the correct sort order. 

     

MasonMA's avatar
MasonMA
Icon for Super User rankSuper User
8 months ago

Hi, 

 

As other users mentioned, the ideal way would be to add a 'Month Number' column in your table and then Sort your Closed Date column by Month Number. This way Month Name Column in your visual will be sorted by Month number instead of the alphabetical way. 

 

Alternatively, since you've enabled 'Auto Date/time' in Option, you can also Drill up and then Expand all down one level, it will also give you the correct sort order.