Search results

Configuring Dashboard Parameters

Dynamic parameter allows user to execute the custom query or stored procedure dynamically based on the parameter while viewing the dashboard. User can also use the parameter in the expression columns.

Add a Dashboard Parameters

Users can create the dashboard Parameter at the datasource level. The dashboard parameter icon is provided as shown in the following image.

Dashboard Parameter icon

Open the Dashboard Parameter window. A default parameter will be added as follows.

Dashboard Parameter window

Modes

There are two different modes in the dashboard parameter as follows:

  1. Literal: Defines the static value of the parameter.

  2. List: Users can select the multiple values that can be used for initial execution.

Literal mode

The literal mode allows you to add the text, number, date, boolean, and range type of values.

Dashboard Parameter Literal Mode

Select the String or Number Type and enter the Current Value as shown in the following screenshot.

Dashboard Parameter String

Select the Date type and also select the date in the date picker for date type parameter.

Dashboard Parameter Date

Select the Boolean type and also select true or false for boolean type parameter.

Dashboard Parameter Boolean

User can add the description for the dashboard parameter.

Dashboard Parameter Description

Click Save to save the added parameter. After the parameter saved successfully, the success message is shown in the footer of the dialog and Add will be enabled at the footer.

Dashboard Parameter Literal Mode

User can provide the range values for number and date type parameters on choosing Selection Type as range.

Selection type for Dashboard Parameter

To add or edit the relative date range for date type parameters, Select the Add Relative Date Range option from drop-down. User can create the relative date ranges. Dashboard Parameter relative range

To remove all relative date range for the data type parameter, Select the Clear Relative Date option from drop-down. User can remove all relative ranges.

Dashboard Parameter relative range clear

List Mode

There are two different types in the list mode as follows:

  1. Manual: The list mode allows user to add any number of values from a same data type, which can be a text, number, or date.

  2. Data Source: The list mode allows user to select the multiple values from the data source.

List Manual type

The list type allows user to add values to the list manually.

Dashboard Parameter - List Manual

User can edit the added values using the double click the value. Also, uncheck or check a eye icon to include or exclude the values.

List mode manual value edit

Users can uncheck or check the values and include or exclude the values using the multi selection combo box.

List mode value select

The list values will be shown as follows while viewing the dashboard, and user can select a value from the list.

List mode preview

User can create parameters with the same name for more than one data sources. When dashboard previewing, data source name will be appended with the parameter name.

Parameter name in preview

List Data Source type

There are three different types in the list data source type as follows:

  1. Data Source: Data fetched from fields for currently dragged tables.

  2. Table: Data fetched from any of the table from current data source.

  3. Custom Query: User can also fetch the data by using the custom query option.

User can select the type of data fetched from Field From drop-down.

List data source Field From

User can select the field where the data to be fetched from Field drop-down.

List data source Field

User can select or unselect and include or exclude the data from the multi selection combo box.

List data source Combo box

In Table type parameter, user can select the table from the current data source from Table drop-down.

List data source Table

In Custom Query type parameter, select the Run to execute the query.

List data source Custom Query

Show In Viewer

When the Show in Viewer option is enabled in the Dashboard Parameters window, then the parameters added in the dashboard will be available in the dashboard preview.

Show in viewer option

Set first value

When the Set first value option is enabled in the Dashboard Parameters window, only then first value is selected from the list of selected values for the parameter.

Set first value option

Edit a Dashboard parameter

Select a parameter from the left panel. Modify the parameters and click the Update.

Update dashboard parameter

Remove a Dashboard Parameter

Select a parameter from the left panel and remove the parameter using the delete icon.

Delete dashboard parameter