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

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