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.
Users can create the dashboard Parameter at the datasource level. The dashboard parameter icon is provided as shown in the following image.
Open the Dashboard Parameter window. A default parameter will be added as follows.
There are two different modes in the dashboard parameter as follows:
Literal: Defines the static value of the parameter.
List: Users can select the multiple values that can be used for initial execution.
The literal mode allows you to add the text, number, date, boolean, and range type of values.
Select the String or Number Type and enter the Current Value as shown in the following screenshot.
Select the Date type and also select the date and time in the date time picker for the date type parameter. The selected date and time values will be filtered based on the selected
Select the Boolean type and also select true or false for boolean type parameter.
User can add the description for the dashboard parameter.
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.
User can provide the range values for number and date type parameters on choosing
Selection Type as range.
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.
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.
There are two different types in the list mode as follows:
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.
Data Source: The list mode allows user to select the multiple values from the data source.
The list type allows user to add values to the list manually.
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.
Users can uncheck or check the values and include or exclude the values using the multi selection combo box.
The list values will be shown as follows while viewing the dashboard, and user can select a value from the list.
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.
There are three different types in the list data source type as follows:
Data Source: Data fetched from fields for currently dragged tables.
Table: Data fetched from any of the table from current data source.
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.
User can select the field where the data to be fetched from
User can select or unselect and include or exclude the data from the multi selection combo box.
Table type parameter, user can select the table from the current data source from
Custom Query type parameter, select the
Run to execute the query.
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.
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.
Select a parameter from the left panel. Modify the parameters and click the
Select a parameter from the left panel and remove the parameter using the delete icon.