Year-Quarter Graphs

[Learnerr]

Hi all,

I have a graph which represents sales per month and i show it by clicking year filter.

I would like to make a graph to represent quarters of 3 years(2020-2021-2022). How can i do that ,please?

Thanks

[MayilVahanan · Accepted solution]

Hi

You can bring quarter column from the script like below and use Quarter and Year as dimension 

'Q' & ceil(month(Date)/3) as Quarter

or

Dual('Q' & ceil(month(Date)/3) &'-'& Year, QuarterName(Date)) as QuarterYear

[Learnerr]

Hello,

,When i add that code into my script it gives error unfortunately.

[MayilVahanan · Accepted solution]

Hi

Can you post the script ?