{"id":8728,"date":"2024-12-12T12:00:42","date_gmt":"2024-12-12T10:00:42","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=8728"},"modified":"2024-12-12T12:02:19","modified_gmt":"2024-12-12T10:02:19","slug":"parametry","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/zvit-interaktyvnyj-deshbord\/parametry\/","title":{"rendered":"Parameters"},"content":{"rendered":"<p>The parameter is a dashboard element that allows to dynamically influence the \u201cExpression\u201d highlight rule.<\/p>\n<p>In order to create a parameter, click the toolbar icon:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_1-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8773\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_1-2.png\" alt=\"\" width=\"348\" height=\"87\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_1-2.png 348w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_1-2-300x75.png 300w\" sizes=\"auto, (max-width: 348px) 100vw, 348px\" \/><\/a><\/p>\n<p>The following window opens:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_2-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8772\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_2-2.png\" alt=\"\" width=\"539\" height=\"418\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_2-2.png 539w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_2-2-450x349.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_2-2-300x233.png 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/a><\/p>\n<p>To add the parameter, click the \u00abAdd\u00bb button. The following parameters are displayed in the window:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_3-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8771\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_3-2.png\" alt=\"\" width=\"539\" height=\"418\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_3-2.png 539w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_3-2-450x349.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_3-2-300x233.png 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/a><\/p>\n<ul>\n<li>Visible \u2013 specifies whether or not the parameter editor is visible in the dashboard Parameters dialog;<\/li>\n<li>Allow Null \u2013specifies whether or a not null value can be passed as a parameter value;<\/li>\n<li>Allow Multiselect \u2013 specifies whether or not multi-selection is enabled for the current parameter. The following limitations are applied to parameters with multi-selection\n<ul>\n<li>Use the \u201cis any of\u201d or \u201cis none of\u201d operators to pass a multi-select parameter to a filter criteria or to the Expression format condition.<\/li>\n<li>Use the \u201cIn\u201d or \u201cNot In\u201d operators to pass a multi-select parameter to a calculated field<\/li>\n<li>Custom SQL queries do not support multi-select<\/li>\n<li>Stored procedures used in SQL and Entity Framework data sources do not support multi-select parameters.<\/li>\n<\/ul>\n<\/li>\n<li>Name \u2013 Specifies the parameter name:\n<ul>\n<li>A name can contain letters, numbers and<\/li>\n<li>A name cannot contain<\/li>\n<li>A name cannot be an empty<\/li>\n<li>The dashboard cannot contain parameters with the same<\/li>\n<li>Names are case-sensitive. For example, you can create the names Parameter and PARAMETER.<\/li>\n<\/ul>\n<\/li>\n<li>Description \u2013 specifies the parameter&#8217;s description displayed;<\/li>\n<li>Look-Up Settings \u2013 specifies the parameter&#8217;s look-up editor settings;<\/li>\n<li>Type \u2013 specifies the parameter type;<\/li>\n<li>Value \u2013 specifies the default parameter\u2019s value(s).<\/li>\n<\/ul>\n<p>Note that when <em>\u201c<\/em>Allow Multiselect\u201d is set to <em>\u201c<\/em>true\u201d, the <em>\u201c<\/em>Value<em>\u201d <\/em>option allows you to select multiple parameter values.<\/p>\n<p>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<p>First, we add a table with the following values:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_4-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8770\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_4-2.png\" alt=\"\" width=\"645\" height=\"391\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_4-2.png 645w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_4-2-450x273.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_4-2-300x182.png 300w\" sizes=\"auto, (max-width: 645px) 100vw, 645px\" \/><\/a><\/p>\n<p>Create two parameters and fill in the fields as follows:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_5-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8769 aligncenter\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_5-2.png\" alt=\"\" width=\"539\" height=\"418\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_5-2.png 539w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_5-2-450x349.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_5-2-300x233.png 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_6-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8768 aligncenter\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_6-2.png\" alt=\"\" width=\"539\" height=\"418\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_6-2.png 539w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_6-2-450x349.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_6-2-300x233.png 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/a><\/p>\n<p>For \u201cReseller Sales Amount\u201d, create an \u201cExpression\u201d highlight rule with the following parameters:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_7-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8767 aligncenter\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_7-2.png\" alt=\"\" width=\"704\" height=\"432\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_7-2.png 704w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_7-2-450x276.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_7-2-300x184.png 300w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><\/a><\/p>\n<p>As a result, the first parameter from the list is displayed in the value field:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_8-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8766 aligncenter\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_8-2.png\" alt=\"\" width=\"704\" height=\"432\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_8-2.png 704w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_8-2-450x276.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_8-2-300x184.png 300w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><\/a><\/p>\n<p>Similarly, double-click the second value field:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_9-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8765\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_9-2.png\" alt=\"\" width=\"704\" height=\"432\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_9-2.png 704w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_9-2-450x276.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_9-2-300x184.png 300w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><\/a><\/p>\n<p>The first parameter will be displayed again, click it and select the \u201cSales2\u201d parameter in the opened list:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_10-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8764\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_10-2.png\" alt=\"\" width=\"704\" height=\"432\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_10-2.png 704w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_10-2-450x276.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_10-2-300x184.png 300w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><\/a><\/p>\n<p>It is only left to choose the color of highlight on the panel:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_11-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8763\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_11-2.png\" alt=\"\" width=\"704\" height=\"432\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_11-2.png 704w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_11-2-450x276.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_11-2-300x184.png 300w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><\/a><\/p>\n<p>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<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_12-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8762\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_12-2.png\" alt=\"\" width=\"419\" height=\"671\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_12-2.png 419w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_12-2-281x450.png 281w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_12-2-187x300.png 187w\" sizes=\"auto, (max-width: 419px) 100vw, 419px\" \/><\/a><\/p>\n<p>Now let us change the range of values: Sales1 = $ 200 000, and Sales2 = $ 2 million.<\/p>\n<p>For this, click the \u201cParameters\u201d icon in the toolbar:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_13-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8761\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_13-2.png\" alt=\"\" width=\"427\" height=\"138\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_13-2.png 427w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_13-2-300x97.png 300w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><\/a><\/p>\n<p>In the opened window enter the corresponding values for each parameter:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_14-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8760\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_14-2.png\" alt=\"\" width=\"494\" height=\"253\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_14-2.png 494w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_14-2-450x230.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_14-2-300x154.png 300w\" sizes=\"auto, (max-width: 494px) 100vw, 494px\" \/><\/a><\/p>\n<p>As a result, we get a table where all the values of \u201cReseller Sales Amount\u201d measure for more than $ 200 000 but less than $ 1 million are highlighted:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_15-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8759\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_15-2.png\" alt=\"\" width=\"417\" height=\"671\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_15-2.png 417w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_15-2-280x450.png 280w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_22_15-2-186x300.png 186w\" sizes=\"auto, (max-width: 417px) 100vw, 417px\" \/><\/a><\/p>","protected":false},"featured_media":0,"parent":4864,"menu_order":277,"template":"","manuals":[17],"class_list":["post-8728","manual","type-manual","status-publish","hentry","manuals-bat-report"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/8728","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual"}],"about":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/types\/manual"}],"up":[{"embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/4864"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=8728"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=8728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}