How can we use value from a calculated field as a parameter value?

[sreyesh]

• I intend to create a parameter value based on the max value of the Date field.
• I created a calculated field for max date value.
• Now, I intend to use this max date value in a subtitle or text field (as parameter) to denote the date till which the data is available.
  How do I achieve this?

[Max]

Parameters cannot be set by a calculated field. They are only set via the default value or changed by an action.

You will either need to set it via the static default or by a dynamic default.

Here is a reference to dynamic defaults.

How to make Dynamic parameter

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 th…

To change it you can use actions.

Setting parameters with Actions

Typically you would use an action of type Navigation Action. It quite straighforward: choose Custom Action> Change the type to Navigation Action > set the parameters to the value you want to assign. (see Creating and editing custom actions in Amazon QuickSight - Amazon QuickSight ) [image] Note that the visual needs to have a field with the target value of the parameter. If you need to do some changes, then create a new calculated field and use that in the visuals. This is a limitation at th…

[sreyesh]

These didn’t quite resolve it;
but Thank you very much, for the replies and suggestions.

As of now have added the date as a table in the first tab of the analysis.