Parameters

The parameter is a dashboard element that allows to dynamically influence the “Expression” highlight rule.

In order to create a parameter, click the toolbar icon:

The following window opens:

To add the parameter, click the «Add» button. The following parameters are displayed in the window:

• Visible – specifies whether or not the parameter editor is visible in the dashboard Parameters dialog;
• Allow Null – specifies whether or a not null value can be passed as a parameter value;
• Allow Multiselect – specifies whether or not multi-selection is enabled for the current parameter. The following limitations are applied to parameters with multi-selection
  • Use the “is any of” or “is none of” operators to pass a multi-select parameter to a filter criteria or to the Expression format condition.
  • Use the “In” or “Not In” operators to pass a multi-select parameter to a calculated field
  • Custom SQL queries do not support multi-select
  • Stored procedures used in SQL and Entity Framework data sources do not support multi-select parameters.
• Description – specifies the parameter’s description displayed;
• Look-Up Settings – specifies the parameter’s look-up editor settings:
• No Look-Up – the user can specify the value of the parameter
• Static List – the user selects a parameter value from a static list
• Dynamic List – the user selects a parameter value defined in a data source
• Type – specifies the parameter type;
• Value – specifies the default parameter’s value(s).

Note that when “Allow Multiselect” is set to “true”, the “Value” option allows you to select multiple parameter values;

• Name – Specifies the parameter
  • A name can contain letters, numbers and
  • A name cannot contain
  • A name cannot be an empty
  • The dashboard cannot contain parameters with the same
  • Names are case-sensitive. For example, you can create the names Parameter and PARAMETER.

Let’s consider the “‘No Look-Up’ parameter type using the following grid as an example (SQL source):

Add the “Category” parameter with the following settings:

Now let’s add this parameter to the grid:

and set the following condition:

As a result, we get the following condition:

Click «OK» to see  that the grid  will be filtered according to the default  category – ‘Bikes’:

To change the current parameter value, click the «Parameters» button in the dashboard title:

Let’s consider the «Static List» parameter type using the same grid as an example. To do this, make the following changes to the parameter settings:

Now, when changing a parameter, we will have access to a list of static values:

Let’s consider the “Dynamic List” parameter type using the same grid as an example.

Go to the “Data Source” tab and add a new query:

In the “Query editor”, click the «Run Query Builder…» button and drop the following table and enable the “All Columns” check box and click «OK»:

Now you should make the following changes to the settings:

Change the default value to “Accessories” to see the result:

You can specify several values in the parameter at the same time. To do this, go to “Parameters” and set the “Allow Multiselect” to “Yes”:

The “Grid” shows the error in its caption because multi-select parameters cannot be used with the “Equals” criteria operator. Click “Edit Filter” and change the operator to “Is any of”:

Click the «Parameters» button in the title and select some parameter values:

As a result, the grid will contain the following data:

Let us create a setting that highlights the “Reseller Sales Amount” value of more than $500,000, but less than $ 1 million for all product subcategories.

First, we add a table with the following values:

Create two parameters and fill in the fields as follows:

For “Reseller Sales Amount”, create an “Expression” highlight rule with the following parameters:

As a result, the first parameter from the list is displayed in the value field:

Similarly, double-click the second value field:

The first parameter will be displayed again, click it and select the “Sales2” parameter in the opened list:

It is only left to choose the color of highlight on the panel:

Now all the values of the “Reseller Sales Amount” measure that are higher than $ 500 000 but lower than $ 1 million for all product subcategories are highlighted in the table:

Now let us change the range of values: Sales1 = $ 200 000, and Sales2 = $ 2 million.

For this, click the “Options” icon in the toolbar:

In the opened window enter the corresponding values for each parameter:

As a result, we get a table where all the values of “Reseller Sales Amount” measure for more than $ 200 000 but less than $ 1 million are highlighted: