Updating a Parameter value dynamically?

Q&A
, , ,
1

I have a parameter of data type string that represents the most recent month in a dataset, which I display to the user. Currently, I need to manually update the “static multiple default values” whenever a new month’s data is added to the dataset via a Glue job.

Instead of manual updates, I’d like this process to be automatic. Is it possible to create a formula or script that automatically assigns the most recent month from the database to the parameter when the dashboard is opened?

I’m quite new to QuickSight, so I appreciate any guidance.

2

I can think of 3 options:

  1. Did you try using rolling date as filter? it can identify the current day and use last day, week, month, etc as filter
  2. You can also use relative date as parameter value but it can only be applied for date type parameter value
  3. To use the most recent month from database, you can use dynamic default parameter value. You can set a custom SQL to get the latest month from database. And assign the value to do a dataset. And take this value as dynamic default value for all users. You can also add all users to a user group and assign value to the group.
3

Thank you! I was thinking of doing step 3, so i’m so glad someone else thinks this is possible.