Dynamic Date Filtering
How can one add a column filter to a widget or dashboard that is relative to an input parameter or variable?
Forum Discussion
Hi Michael-Schram,
Your use-case sounds like one of two options:
- The ability to control a filter as part of the dashboard (e.g., a drop-down box that lets you choose a value, or a text box that lets you type in a date)
- The ability to control a "variable" via a textbox and allow it to affect the dashboard results (a.k.a. "What-If Analysis")
Can you please elaborate on your use case so I can answer the question?
Ophir_Buchman , the use case would be as follows:
1. Select a date based value in a widget filter (i.e. month or date range).
2. Allow various widgets within the dashboard to filter a different date range / period, relative to the user's filter selection. For example, one widget might display a KPI for the six month prior to the user's selection and another might display the same KPI for the user's selection.We've found methods to accomplish this within creative cube architecture but I'm inquiring if the web application has its own solution.
