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,
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.
Retrieving data ...