Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Graph year and quarter

Hi I need help with the following: I have already a column (see below Year & Quarter (text)) when I add to shared axis "Year & Quarter" is only showing Q1 and the a sum up of all Q2, Q3, Q4 in the gr...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

amitchandak 

 

right now shows like this

 

it is supposed to show all years in the order of 2006 Q1, Q2, Q3, Q4, 2007 Q1, Q2, Q3, Q4, 2008 Q1, Q2, Q3, Q4, 2009 Q1, Q2, Q3, Q4, 2010 Q1, Q2, Q3, Q4...AND SO ON until 2021 Q1, Q2, Q3. 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

amitchandak 

even though it says dont summarize it, it is summing up  instead of bringing each data individually in order 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak Hi again I was able to use the quarter as a column series but then the line value should also bring me quarterly results instead is showing a sum of the 4 quarters, how can i have the line value to bring me all values then it would work

     

    • Icey's avatar
      Icey
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi Anonymous ,

       

      Currently, you will need to create a measure for each quarter like below:

       

       

       

      Best Regards,

      Icey

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.