1 2 Previous Next 15 Replies Latest reply on Oct 15, 2019 3:17 AM by Abdul Ahad

    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)]



      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?



        1 2 Previous Next