Set dashboard parameters

Dashboard panels can pass parameters into reports, charts, URLs, and data tables.

Use parameters to filter data, drive prompts, and link panels together.

Understand where parameters come from

Some content defines its own parameters.

For example, an .xaction or .prpt can expose parameters and default values.

You’ll see them under Parameters in the dashboard Edit pane.

Parameter names in the source file are fixed.

You can’t rename them.

You can’t add or remove them.

Other panel types let you define your own parameters.

For example, charts created with Chart Designer, embedded URLs, and data tables.

For these, you can set both the parameter name and value.

Get started with the Query Editor

When you place a chart in a dashboard panel, you use the Query Editor.

The Query Editor retrieves data from a database for your chart or data table.

Add conditions to filter the data.

Use parameters if you plan to:

• Use dashboard prompts.

• Link one panel to another.

Example: link a pie slice selection to an adjoining data table.

The data table can update when someone clicks a pie slice.

You do this by using a parameter in the query condition.

Example of content linking

Create chart or data table parameters

Create a parameter by entering a name in curly braces in the Value field.

Example: {TERRITORY}.

Set a default value (source) for the parameter.

Example: NA (North America).

When the chart or data table runs, it uses the current parameter value.

Dashboard consumers can change the value through prompts or interactions.

Filter parameter example

To define multiple default values, separate them with a pipe (|).

Example:

NA|EMEA|APAC

If you want a static query value, don’t use curly braces.

This disables Default (value) because there is no parameter.

Static query

Add dynamic dashboard titles

Dashboard panels can show their current parameter values in the panel title.

1

Open the Edit pane

Click the Edit (pencil) icon on the top toolbar.

2

Select the panel

Click the report or panel that has the parameters you want to show.

3

Add the parameter to the title

Click Add Parameter.

The parameter appears after the title.

Editing parameter

4

Apply changes

Click Apply.

5

Exit edit mode

Close the Edit pane by clicking the Edit (pencil) icon again.

The title now shows the parameter values.

Parameter applied

Limits

On Windows, URL parameters are limited to 2,048 characters.

This limit excludes the URL path itself.