topic Re: Year-Quarter Graphs in App Development

Year-Quarter Graphs

Learnerr — Fri, 14 Oct 2022 05:59:14 GMT

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 — Fri, 14 Oct 2022 07:14:36 GMT

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

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

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

Learnerr — Mon, 17 Oct 2022 11:44:56 GMT

Hello,

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

MayilVahanan — Wed, 19 Oct 2022 07:39:14 GMT

Can you post the script ?