How do you create a common filter for two different widgets when the filtered dimensions are different, but both are of type date?
Hi Everyone!
I have two widgets with line vs time graphs.
I need to make a common filter by date for both, but these widgets use different date dimensions.
How I can to do this?
Hi Semen,
You can accomplish this using Pivot Variables + Calculated Members.
You will need to define a pivot variable named "CommonDate" (or whatever, we will use "CommonDate" for this example). This Pivot Variable will contain values like "65211". The Patients Cube in SAMPLES contains an example YEAR Pivot Variable.
You will then define two calculated members:
1) Start Date = "[StartDate].[H1].[StartDay].&[$variable.CommonDate]"
2) End Date = "[EndDate].[H1].[EndDay].&[$variable.CommonDate]"
You can then create an "Apply Pivot Variable" control in your dashboard pointing to the "CommonDate" pivot variable. This date will then be applied to both dimensions even though they have different names.
Thank you, Peter!
Just want to mention that Samples can be installed from Open Exchange.
and also it worth to mention that pivot variable deployment is not that straightforward as supposed to be.