Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello to all,
I want to develop a quarter rolling chart.
I already have a QuarterID field in my master calendar, which gives me a way to perform the set analysis for the chart.
Below, my master calendar:
The problem is that I don't have a field to use such as a 'Quarter-Year' to use as my dimension for the chart.
Using the field QuarterID as a dimension, I have the information I need, but not in a 'friendly user way'.
I need a field that says 'Q4-2015' in the place of '12' in the chart above.
How can I create a field like this in my master calendar?
Thanks for your support!!
Create it like this may be:
Dual('Q' & Ceil(Month(Temp_Date)/3) & '-' & Year(Temp_Date), QuarterStart(Temp_Date)) as QuarterYear
Or create your QuarterID this way: Dual(Quarter & '-' & Year, Autonumber(Quarter & Year,'QuarterID')) as QuarterID
Sunny,
Thanks for the support. I used the expression below to solve my issue, based on your and Gysbert answer.
Year(Temp_Date) & '-' & 'Q' & Ceil(Month(Temp_Date)/3) | as [Quarter - Year] |
Kind regards,
Marco
Gysbert,
Thanks for the support. I used the expression below to solve my issue, based on your and Sunny answer.
Year(Temp_Date) & '-' & 'Q' & Ceil(Month(Temp_Date)/3) | as [Quarter - Year] |
Kind regards,
Marco