Passing column filter values in report expressions

Use GETPROMPTVALUE to pass a user-selected value from a prompt or filter into an expression. When passing a column name, Birst adds the filter to the WHERE clause.

Syntax

GETPROMPTVALUE('filter_column_name', 'default_value')

The column name for Original Dashboards is the column name in the Parameter name field, not the display name. For Dashboards 2.0 it is the column name, not the filter name. Both of these names use the format dimension_name.attribute_name.

For example, GETPROMPTVALUE('Time.Year','2014')