Create a parameter for date on an analysis with multiple datasets

Question & Answer
1

how can I create a date parameter that uses different datasets in one analysis?
I have 4 datasets that have different date titles
dataset1 date name utc_time
dataset2 date name creation_datetime
dataset 3 date name utc_time
dataset 4 date name capture_date
all date types are yyy/mm/dd HH:mm:ss

2

Hi @nsaleh ,

Thanks for posting your questions on the QuickSight Community Q&A Forum!

You can create Date parameter and set default date as fixed date or relative date , then provide format you need while creating control. In this case you can use - YYYY/MM/DD HH:mm:ss

While creating visual with your respective dataset you can use same date parameters to add filter.

Here is quick example -

I have used pSelectedDate to apply filter on Order Date in dataset 1

image
image1108×432 100 KB

Similarly , i used pSelectedDate to apply filter on recall notification date in dataset 2

image
image1120×736 125 KB

We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.

Thanks
Neeraj

2 Likes
3

Hi Neeraj,

Thanks for replying back. This has perfectly worked! didn’t imagine it’s that easy, really appreciated.