The currently selected value(s) for query parameters, as well as the number of rows in the results of a report can be used in the report title, description or no-data message. To achieve this, special query parameter expressions can be embedded in the text and will be replaced with the currently selected value. For example, given a custom filter named selected_countries the following report title dynamically updates according to the selected countries in the filter:
Airports in {selected_countries}
A default value can be provided when the filter has no value selected with the following special syntax:
Airports in {selected_countries|All countries}
The complete list of query parameter expressions that can be used:
{<filter_name>} |
Replaced with the currently selected value or values (concatenated with comma) or empty string if no value is selected. |
{<filter_name>|<default value>} |
Replaced with the currently selected value or values (concatenated with comma) or the "default_value" string if no value is selected. |
{aggregation} |
Replaced with the currently selected time aggregation period. |
{timerange} |
Replaced with a formatted string for the currently selected time range. |
{result_rows} |
Replaced with the number of rows in the current report SQL results: "1", "2", etc. |
{result_rows_label} |
Replaced with a complete and correctly pluralized label: "1 row", "2 rows", etc. |