![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_25_1-2.png\")
<\/a><\/p>\nThe following window opens:<\/p>\n
To add the parameter, click the \u00abAdd\u00bb button. The following parameters are displayed in the window:<\/p>\n Note that when \u201cAllow Multiselect\u201d is set to \u201ctrue\u201d, the \u201cValue\u201d option allows you to select multiple parameter values;<\/p>\n Let’s consider the “‘No Look-Up’ parameter type using the following grid as an example (SQL source):<\/p>\n Add the \u201cCategory\u201d parameter with the following settings:<\/p>\n Now let’s add this parameter to the grid:<\/p>\n and set the following condition:<\/p>\n As a result, we get the following condition:<\/p>\n Click \u00abOK\u00bb to see \u00a0that the grid\u00a0 will be filtered according to the default\u00a0 category \u2013 \u2018Bikes\u2019:<\/p>\n To change the current parameter value, click the \u00abParameters\u00bb button in the dashboard title:<\/p>\n Let’s consider the \u00abStatic List\u00bb parameter type using the same grid as an example. To do this, make the following changes to the parameter settings:<\/p>\n Now, when changing a parameter, we will have access to a list of static values:<\/p>\n Let’s consider the \u201cDynamic List\u201d parameter type using the same grid as an example.<\/p>\n Go to the \u201cData Source\u201d tab and add a new query:<\/p>\n In the \u201cQuery editor\u201d, click the \u00abRun Query Builder\u2026\u00bb button and drop the following table and enable the \u201cAll Columns\u201d check box and click \u00abOK\u00bb:<\/p>\n Now you should make the following changes to the settings:<\/p>\n Change the default value to \u201cAccessories\u201d to see the result:<\/p>\n You can specify several values in the parameter at the same time. To do this, go to \u201cParameters\u201d and set the \u201cAllow Multiselect\u201d to \u201cYes\u201d:<\/p>\n The \u201cGrid\u201d shows the error in its caption because multi-select parameters cannot be used with the \u201cEquals\u201d criteria operator. Click \u201cEdit Filter\u201d and change the operator to \u201cIs any of\u201d:<\/p>\n Click the \u00abParameters\u00bb button in the title and select some parameter values:<\/p>\n As a result, the grid will contain the following data:<\/p>\n Let us create a setting that highlights the \u201cReseller Sales Amount\u201d value of more than $500,000, but less than $ 1 million for all product subcategories.<\/p>\n First, we add a table with the following values:<\/p>\n Create two parameters and fill in the fields as follows:<\/p>\n For \u201cReseller Sales Amount\u201d, create an \u201cExpression\u201d highlight rule with the following parameters:<\/p>\n As a result, the first parameter from the list is displayed in the value field:<\/p>\n Similarly, double-click the second value field:<\/p>\n The first parameter will be displayed again, click it and select the \u201cSales2\u201d parameter in the opened list:<\/p>\n It is only left to choose the color of highlight on the panel:<\/p>\n Now all the values of the \u201cReseller Sales Amount\u201d measure that are higher than $ 500 000 but lower than $ 1 million for all product subcategories are highlighted in the table:<\/p>\n Now let us change the range of values: Sales1 = $ 200 000, and Sales2 = $ 2 million.<\/p>\n For this, click the \u201cOptions\u201d icon in the toolbar:<\/p>\n In the opened window enter the corresponding values for each parameter:<\/p>\n<\/a><\/p>\n<\/a><\/p>\n\n
\n
\n
\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n