2 Replies Latest reply on Feb 15, 2016 6:11 AM by Ronda Ficklin

    Using a custom date selector, when quarter is selected, it defaults to calendar year quarter and not fiscal quarter

    Ronda Ficklin

      I have a 2 fold issue. I have created a line chart that I needed to control easily to reflect activity over time (quarter, month, week). I would love to use the built in hierarchy, but you can not easily drill back up to year from quarter.

      To resolve this problem, I created a customer parameter with Quarter, Month, Week.


      Here is my parameter formula:

      CASE[Select a Timeline], WHEN 'Quarter' THEN [Quarter], WHEN 'Month' THEN [Month], WHEN 'Week' THEN [Week] End.


      I also created a calculated field I call Date Selector.

      Finally, I created custom dates (detail Quarters, Months, Week Numbers).


      That all works GREAT.


      Now, the x axis on the chart is my problem. Right now it is Month, Year.


      My Fiscal year begins in August (my Default Properties, Fiscal Year start is set to August).


      When I change the X axis to QQQ YYYY MMM, the quarter defaults to a calendar year value (August is Q3, 2015) instead of my fiscal year (August is Q1, FY 2016).


      I am sure there is some way to create a calculated field to help resolve this issue, but I haven't come across a solution for this yet.


      Can someone assist?

      I have attached a screen capture of my axis.