How to make Dynamic parameter

If I open dashboard it should reflect current date in parameter,is it posible in qs.

1 Like

Hi,

check out this it may help you :slight_smile:

1 Like

only fixed start date and end date is used here but what i want is end date should be change to tomorrow date automatically if i open dashboard tomorrow.

Currently the solution is to create a dataset that is refreshed daily and which keeps the value of today’s date. Then you can use this dataset to set up a dynamic default for the parameter. You can see the last section here on how to set up Dynamic Default Parameters:

You need to keep in mind that for dynamic defaults you need to provide a username or a groupname. So you, in your dynamic defaults dataset, you would need to create a group for all users or else keep adding all your users into this dataset.

One simple way to create the Dynamic Defaults dataset with your default dates (without requiring any storage) is to create an Athena dataset based on the SQL query below. Then set up a daily SPICE refresh to start after midnight. Upon refresh, the field values will be updated and your dashboards will start showing the updated default dates.

WITH quicksight_users as (
  SELECT username, groupname
  FROM
    (VALUES
      (NULL, 'group1'), // Use this if all your users are within a group

      ('user1', NULL) // Use this if you don't have a group for all users (but need to add an entry for every QuickSight user

 ) AS users(username, groupname)
)

SELECT
  username, groupname,
  CURRENT_DATE as today,
  CURRENT_DATE + INTERVAL '1' DAY AS tomorrow,
  CURRENT_DATE - INTERVAL '1' DAY AS yesterday

FROM
  quicksight_users