4 Replies Latest reply: Jan 20, 2016 1:05 PM by Marco Arruda RSS

    Master Calendar Issue - how to include quarter-year

    Marco Arruda

      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:


      Quarter-Year_Master Calendar_Community Question-1.PNG


      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'.


      Quarter-Year_Master Calendar_Community Question-2.PNG


      Quarter-Year_Master Calendar_Community Question-3.PNG


      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!!