Datapicker dynamic default parameter

Q&A
,
1

Hi

Adding a dynamic default parameter to a date parameter works to the extent that the datepicker control shows the DDP, but the filtered table does not filter to the DDP value that is shown in the controls section. Additionally, changing the value in the datepicker control does not filter the table. The table is always showing all the data.

However, as a workaround, I CAN … convert the date to a string, then use the string as the DDP for another parameter, then show that control and it works. But the list of values in the filter list is a list of strings, and displayed ascending and cannot be changed to descending(?) .

Random SO comments seem to indicate that the datepicker does not work with DDP.

Any suggestions?

2

Hi @albatross666

Welcome back to QuickSight Community .

As part of my testing I was able to pass the dynamic default parameter for a date parameter and its rightly showing up in the control. And even if i tried to change the date picker value could see the selected dates are passed through parameter and gets applied as filter in the visual .

Could you please check the DPP dataset is rightly created with user name & default date values .

  1. DDP dataset with default value as 01-Jan-2024

    image
    image1274×343 23.1 KB

  2. Date parameter with DDP configured in the analysis

    image
    image1243×631 67.7 KB

    image
    image1121×573 54.9 KB

  3. Enable the control on the parameter and used the parameter to filter the visual

    image
    image1113×496 41.4 KB

  4. User selected date values are passing through correctly

    image
    image1081×668 63.8 KB

Could you please cross check and let us know .

Thanks
VInod

1 Like
3

Really odd, but I got it to work … not sure if it’s important but the difference that I noticed is that your DPP data is from Excel and mine is from Redshift …

Here is how I got it to work … I used SPICE and SQL with the trunc function on the date in the table (it still shows the date with a timestamp in the preview … like in your image 1 for Default-Date) and it works now.

I took your hint from “Could you please check the DPP dataset is rightly created” … and since I could do a DPP with strings, your hint make me think about the data in the date field.

Thanks for taking the time to respond in depth with screenshots and all!

1 Like