Forum Discussion

unnijoy's avatar
unnijoy
Post Prodigy
6 years ago

Quarter table

Please help to create a table with the below criteria.   I have a Month Column in my tables. From this i need creatre another table with Quarter and sort it in Descending Order.   My Q1 is from D...
Need Help
dobregon's avatar
dobregon
Impactful Individual
6 years ago

As i see your quarters are not following the normal division in a year, in any case there are only 4 quarters so you can create a simply column calculated with IF

QuarterNum = IF( (Month = 12 || Month = 1 || Month = 2 ), 1, IF( (Month = 3 || Month = 4 || Month = 5 ), 2, IF( (Month = 6 || Month = 7 || Month = 8 ),3,4)))

 

unnijoy's avatar
unnijoy
Post Prodigy
6 years ago

Hi dobregon ,

 

thanks for your quick reply.

 

Can you please help me to get this in the format like QTR 1 - 2020. And when we use this in graph can we sort it like Latest quarter will come first.

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    unnijoy , Try Like

    Create a new column like, hope you have qtr no,

    Qtr Name = "QTR " & [Qtr No] & " - " & [Year]

    • unnijoy's avatar
      unnijoy
      Post Prodigy
      6 years ago

      Hi amitchandak ,

       

      I create a calculated column by combining Qtr and year. But still i am not able to sort it when i use that in x axis. Like latest QTR first.

       

      So the login what i use is I take the month number. And i use Switch function to get Quarter based on month number .

       

      For example if month number is 12 the switch will give me Q1. I i use to get the year using the Year function. 

      If month number is 12 then Q1 && Year (Date)+1. So i will get like below

      For December 2019= Q1 2020.

       

      Now my issue is with sorting. How to get the sorting done in this.

      • dobregon's avatar
        dobregon
        Impactful Individual
        6 years ago

        unnijoy now that you have the column with the format of QTR, number and year that you want. then you have in the X axis.

        if you click in the visual you will see 3 points on the top right, click on this, select sort ascending by and here select your X axis and then you will have your x axis sorted like Q1 2020, Q2 2020, Q3 2020, etc