Passing parameter filter values in report expressions

Use GETPROMPTVALUE with a parameter to pass a value that is used to control other functions, without using a WHERE clause.

Syntax

GETPROMPTVALUE('parameter_name', 'default_value')

The prompt name for Original Dashboards is the Prompt Parameter Name/Change parameter name for report expression prompts.

For Visualizer and Dashboards 2.0 expressions it is a parameter filter name.

Simple Example of a Parameter Filter

For example, in Dashboard 2.0 create a parameter filter called ConstantsParameter with the radio button values 1,2,3. Then create a KPI with the following expression:

(GETPROMPTVALUE('ConstantsParameter', '1'))

On the dashboard when you change the filter, the value of the KPI also changes.

To take the example one step further, create a Visualizer table with a quantity column and a column based on an expression that multiplies quantity by the user-selected constant:

[Order_Date: Sum: Quantity]*INTEGER(GETPROMPTVALUE('ConstantsParameter', '1'))

Note: Remember that you must cast the parameter as an integer, and that we recommend supplying a default value.

On the dashboard when you change the filter, the value of the expression column shows the multiple.