Can we use relative date filter for 2 datasets to work in sync?

Question & Answer
, , ,
1

Hi All,

I am working on a dashboard that uses 4 datasets. I am trying to configure a relative date filter control that filters all the visuals (visuals from all 4 datasets). Since syncing filters between datasets are to be done using parameters, I am unable to configure the relative date selector once I enable parameters.

Is there a workaround for this ?

Thanks.

2

@prantika_sinha filter can be tied with a dataset.
if you have different datasets, you probably have to create a separate filter and set the value of that with a dynamic parameter. so all filters have the same value.

some ref links:

1 Like
3

Thanks @neelay ,
I am aware of the parameter solution, but that takes away the option to set up a relative date filter control.
If we configure parameter in filter, we can only add a date picker as the go to option.

Is there any way to use the relative date filter control along with parameterized config?

4

@prantika_sinha Probably not

1 Like
5

Hi @prantika_sinha,

You can use a parameter with a relative date filter if you select “Last N periods” or “Next N periods”. You’ll have to create a parameter of type integer for the value of N.
image

1 Like
6

Thanks @David_Wong. I still think this wont help me sync the filters. I can only limit the last N period here through this.
Let me rephrase my ask : How do i sync 2 relative date filters applied in 2 different datasets?

7

Do the date fields in your 2 datasets have different names?

If they have the same name and you select “All applicable visuals”, the value that should set for N through your parameter will get applied to all visuals across all datasets that have a field with that name.
image