Hi @isabelapt,
You need to create a dataset that looks like this and use it to set the dynamic default value of your parameter. There’s one row for every username in Quick Sight. Use SQL to find the max date in your dataset and add it to every row of the dataset.
| UserName | MaxDate |
|---|---|
| Username1 | 2025-02-05T00:00:00.000Z |
| Username2 | 2025-02-05T00:00:00.000Z |
| Username3 | 2025-02-05T00:00:00.000Z |
If you have a group containing all your users, you can set the max date for the entire group.
| GroupName | MaxDate |
|---|---|
| Group1 | 2025-02-05T00:00:00.000Z |