Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have used the quartname command to create a field which shows results as Jan-Mar 2013, Apr-Jun 2013, Jul-Sep 2013 etc.
Is it possible to label this field Q1 2013, Q2 2013, Q3 2013 etc?
Thanks,
Daniel
Don't you want the field to be named "Quarter"?
And in your Quarter field, you have rows such as Q1 2013, Q2 2013 etc?
Using this approach, you can use your Quarter field as a dimension in your datamodel and visualize your calculations by Quarter.
The approach which you suggested, to have separate fields for Q1 2013 and Q2 2013 etc., makes no sense in a fact - dimensional data model.
Use the following in script:
(Calendar_Year&'-'&'Q'&Ceil(Month/3), Calendar_Year*100+Ceil(Month/3)) as QuarterYear