Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi
Can you post the script ?
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
Hello,
,When i add that code into my script it gives error unfortunately.
Hi
Can you post the script ?