Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Issues sorting quarters and year

Hi Everyone,

 

I hope you can help me with my problem. I'm creating a visual wherein the X- AXIS should be sorted like this :

 

 

Q1 2018 | Q2 2018 | Q3 2018 | Q4 2018 | Q1 2019 | Q2 2019 | Q3 2019 and so on

 

but whats happening is

 

Q1 2018 | Q1 2019 | Q2 2018 | Q2 2019 | Q3 2018 | Q3 2019 and so on

 

I have a date table and I sort by column the QUARTER column by MONTHYEAR(integer) but it causing an error

 

DateTable

 

Thank you in advance! :)

 

Need Help
Tutorial Requests
  • judspud's avatar
    judspud
    7 years ago

    Hi Anonymous 

     

    Try creating a column that is numerical as the year followed by the quarter

     

    for example 2017 Q1 = 20171, 2017 Q2 = 20172....

     

    One method could be 'QuarterOrder = [Year]*10 + [QuarterOfYear]'

     

    You can then sort the Quarter column by the QuarterOrder column to create the correct order

     

    Hope this helps

     

    Thanks,

    George

2 Replies

  • judspud's avatar
    judspud
    Solution Supplier
    7 years ago

    Hi Anonymous 

     

    Try creating a column that is numerical as the year followed by the quarter

     

    for example 2017 Q1 = 20171, 2017 Q2 = 20172....

     

    One method could be 'QuarterOrder = [Year]*10 + [QuarterOfYear]'

     

    You can then sort the Quarter column by the QuarterOrder column to create the correct order

     

    Hope this helps

     

    Thanks,

    George

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      This solved my problem! Thank you judspud !