I’m working on a dashboard where each visual is connected to a separate dataset. Is there a way to create a single relative date filter that will work for all of the visuals, instead of creating a separate filter/control for each one since they don’t share a date field?
I’ve tried creating a parameter, but I’m having issues with getting it to connect with all of the visuals. Any help would be appreciated!
Hi Jrvish, have a look at this and see if that helps: Filter Across datasets, across pages, all datasets have [Customer Name] column. Summary is that you can either create parameter and use with a control or create join between the data set tables (Joining data - Amazon QuickSight) . Hope that helps.
I’ve been attempting the parameter way, but I still am having issues with it connecting to all of the datasets. Unfortunately, the sets are fairly large and there are 4 of them (so far), without a common field, so I’m not sure that would would work in this case.
What about creating a join between the datasets - is that an option? maybe worth giving that a go if the parameter creation is causing trouble. Also maybe share what issues are you having with the parameter as difficult to help without knowing more.
Unfortunately, the data sets are too large to join in QS without it throwing errors. We might try to do it on the backend.
In the meantime, I was able to set up a start date and end date control and connect them to a parameter that works for all of the visuals. It’s just not super user friendly that way since they would have to pick a specific date for each, which would be especially annoying if wanting to view by quarters. On the individual filters, I can pin them to the top and get the type of date range filter that I’m hoping for, but they obviously only work for the one visual, since they are all from different data sets.