· Jul 17, 2019

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?

Discussion (3)2
Log in or sign up to continue

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.