0
Is there a way to create a parameter for a user to choose the time display (eg month, quarter, year)?
Our users would like to be able to choose, on a presentation, to display all the discoveries by either week, month, quarter or year. Is there a way to have a drop down that would change each discovery to display the data based on the users selection?
3 replies
-
To clarify, we want the disoveries to show the values based on the time selected. For example, if they choose week it would show weeks in the discovery. If they choose month it would show months and so on. Not like time intelligence that only shows one date with values that are MTD, YTD, etc.
-
Technique #1: tedious, but simple
- create a global parameter that has 4 switches : week, month, quarter, year
- build each discover report 4 times: one for each date range
- in a presentation, use the mini-tab display for each visual.
- wire up the global parameter to switch visual you are seeing in the mini-tab
- for the seamless magic, hide the tabs on the mini tab
Technique #2: smarter, but a little more complicated
- use the same global parameter you built above.
- create a custom column using a 4 way "if" or case statement - to change the column's values to weeks, months, quarters, years. Feed the parameter into this logical switch statement.
- Use the custom column to drive each report used in the presentation. Use the parameter to switch the custom column's dates.