Can we use one date relative filter for two data sets

Question & Answer
,
1

so here i have two visuals which has two different data set in a single analysis so here i want relative date filter applied to two visuals so how is it possible

2

Hello Megh,

First of all Welcome to the QuickSight Community.

To apply a relative date filter to two visuals with different datasets in a single analysis, you have several options:

You can create a parameter with the data type Datetime, add a control for this parameter, and then add a custom filter for your date fields in each visualization using this parameter. for reference see here

you may also refer see use case 2 - Using QuickSight parameters and controls to drive interactivity in your dashboards | AWS Big Data Blog

Hope this gives some idea.

Cheers,
Deep

3

image
image276×485 16.2 KB

Hi Deep,

Thanks a lot for the warm welcome and for sharing the suggested approach — I appreciate it!

However, the solution you mentioned doesn’t fully address my use case. I’m specifically looking to use the same relative date filter UI (like the one we get when applying a filter directly on a date field — e.g., “Previous Year”, “This Year”, etc., as shown in the screenshot) across two visuals that are based on different datasets.

The goal is to have one common relative date control (with the same UI options) that applies the same kind of filtering to both visuals, even though they come from different datasets. I’m trying to avoid creating separate filters for each dataset or going the parameter route unless it fully replicates the same UI functionality.

Is there a way to achieve that?

Thanks again,
Megh

4

Hello Megh,

you could do that only via parameter control which i shared earlier or may be join the data set prior to creating an analysis.

Thank you.

Deep

5

thanks deep for your response