Forum Discussion

gabrielmission7's avatar
gabrielmission7
Frequent Visitor
3 years ago
Solved

X-axis Timeframe Sorting Issue

Hello,

 

I have a "Line and Stacked Column Chart" with X-axis running as timeframe that is currently ordered as follows:
2015, 2016, 2017, 2018, 2019-01, 2019-02, ... , 2019-12

I'd like to rename them as follows:

 

FY 2015, FY 2016, FY 2017, FY 2018, Jan, Feb, ..., Dec

However, as soon as I change to the renamed format, the sorting is all messed up. Any suggestions?

 

TIA!

 

Gab

Need Help
  • mahenkj2's avatar
    mahenkj2
    3 years ago

    Hi gabrielmission7 

     

    In such coditions, you may use an additional column with sorting order as desired and sort the x-axis column with this sort column.

     

    Please let me know if it is clear enough for you. Search 'Sort by column' furnction report page:

     

     

     

    Hope it helps.

     

2 Replies

  • mahenkj2's avatar
    mahenkj2
    Solution Sage
    3 years ago

    Hi gabrielmission7 

     

    In such coditions, you may use an additional column with sorting order as desired and sort the x-axis column with this sort column.

     

    Please let me know if it is clear enough for you. Search 'Sort by column' furnction report page:

     

     

     

    Hope it helps.