14 Replies Latest reply on Sep 29, 2017 5:52 PM by Allen Kei

    change date field level with parameter

    Doug Erickson

      I have a date field in the column shelf that is setting the x-axis.  I would like to use a parameter to change the level of the date pill to either continuous 'Year' or continuous 'Quarter'. 

       

      I have tried making custom date fields that are fixed on Year or Quarter, which work great by them selves, but when I create a calculated field with this formula,

       

      Case [Parameter]

           when "Quarter" then [Date (Quarters)]

           when "Year" then [Date (Years)]

      end

       

      it just creates a third date field that stays at a fixed level on the column shelf.  I need it to be a continuous field for title and caption reasons.

       

      Any Ideas?

       

      Doug