https://wiki.onqpr.com/pa/index.php?title=Dropdown_List_Selector&feed=atom&action=historyDropdown List Selector - Revision history2024-03-29T01:12:15ZRevision history for this page on the wikiMediaWiki 1.39.1https://wiki.onqpr.com/pa/index.php?title=Dropdown_List_Selector&diff=23946&oldid=prevOllvihe: /* Dropdown List Selector settings */2023-12-11T20:07:47Z<p><span dir="auto"><span class="autocomment">Dropdown List Selector settings</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 20:07, 11 December 2023</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l24">Line 24:</td>
<td colspan="2" class="diff-lineno">Line 24:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Maximum rows''': Maximum number of items shown by the list. This setting can be used if desired to show only the most relevant items. Listing more than thousands of items may cause the list to work very slowly, so showing lot of items, consider what's the practical maximum from the performance point of view.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Maximum rows''': Maximum number of items shown by the list. This setting can be used if desired to show only the most relevant items. Listing more than thousands of items may cause the list to work very slowly, so showing lot of items, consider what's the practical maximum from the performance point of view.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''1. measure''': The dropdown list can optionally show aggregated/summarized information for each of the shown item. When the first measure is selected, possibility to define a second measure appears. The measures work similarly as [[QPR_ProcessAnalyzer_Chart#Selecting_Measures.2C_Dimensions_and_Columns|measures in charts]].</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''1. measure''': The dropdown list can optionally show aggregated/summarized information for each of the shown item. When the first measure is selected, possibility to define a second measure appears. The measures work similarly as [[QPR_ProcessAnalyzer_Chart#Selecting_Measures.2C_Dimensions_and_Columns|measures in charts]].</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* '''Follow dashboard filters''': </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* '''Follow dashboard filters''': <ins style="font-weight: bold; text-decoration: none;">Whether dashboard filters are applied to the query when getting the list items.</ins></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* '''Chart filter''': Filter rules that are applied to the <del style="font-weight: bold; text-decoration: none;">model </del>when getting the list items.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* '''Chart filter''': Filter rules that are applied to the <ins style="font-weight: bold; text-decoration: none;">query </ins>when getting the list items.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''[[Chart_Linked_Settings|Linked settings]]'''</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''[[Chart_Linked_Settings|Linked settings]]'''</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Model''': Model to which the query is made to get the list items.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Model''': Model to which the query is made to get the list items.</div></td></tr>
</table>Ollvihehttps://wiki.onqpr.com/pa/index.php?title=Dropdown_List_Selector&diff=23945&oldid=prevOllvihe: /* Dropdown List Selector settings */2023-12-11T20:06:33Z<p><span dir="auto"><span class="autocomment">Dropdown List Selector settings</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 20:06, 11 December 2023</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l28">Line 28:</td>
<td colspan="2" class="diff-lineno">Line 28:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''[[Chart_Linked_Settings|Linked settings]]'''</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''[[Chart_Linked_Settings|Linked settings]]'''</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Model''': Model to which the query is made to get the list items.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Model''': Model to which the query is made to get the list items.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* [[QPR_ProcessAnalyzer_Chart#Layout_Settings|<del style="font-weight: bold; text-decoration: none;">layout </del>settings]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;">'''</ins>[[QPR_ProcessAnalyzer_Chart#Layout_Settings|<ins style="font-weight: bold; text-decoration: none;">Layout </ins>settings]]<ins style="font-weight: bold; text-decoration: none;">'''</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Variable value format ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Variable value format ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>When using a Snowflake model, the Dropdown List Selector stores the variable using the [[Stringified_Value_Format|stringified format]]. When using an in-memory model, the variable values is stored in the json format (https://www.w3schools.com/js/js_json_intro.asp). The reason for the different behavior is that the stringified format is more versatile, so it was taken into use for Snowflake (which was implemented after the original in-memory). The [[Chart_Linked_Settings|linked settings]] in charts by default use the stringified format, so when working with in-memory models, you need to change the ''valueFormat'' parameter in the linked settings.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>When using a Snowflake model, the Dropdown List Selector stores the variable using the [[Stringified_Value_Format|stringified format]]. When using an in-memory model, the variable values is stored in the json format (https://www.w3schools.com/js/js_json_intro.asp). The reason for the different behavior is that the stringified format is more versatile, so it was taken into use for Snowflake (which was implemented after the original in-memory). The [[Chart_Linked_Settings|linked settings]] in charts by default use the stringified format, so when working with in-memory models, you need to change the ''valueFormat'' parameter in the linked settings.</div></td></tr>
</table>Ollvihehttps://wiki.onqpr.com/pa/index.php?title=Dropdown_List_Selector&diff=23944&oldid=prevOllvihe: /* Dropdown List Selector settings */2023-12-11T20:06:21Z<p><span dir="auto"><span class="autocomment">Dropdown List Selector settings</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 20:06, 11 December 2023</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l28">Line 28:</td>
<td colspan="2" class="diff-lineno">Line 28:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''[[Chart_Linked_Settings|Linked settings]]'''</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''[[Chart_Linked_Settings|Linked settings]]'''</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Model''': Model to which the query is made to get the list items.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Model''': Model to which the query is made to get the list items.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* <del style="font-weight: bold; text-decoration: none;">In addition, there are the same </del>[[QPR_ProcessAnalyzer_Chart#Layout_Settings|layout settings]] <del style="font-weight: bold; text-decoration: none;">available as in charts.</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* [[QPR_ProcessAnalyzer_Chart#Layout_Settings|layout settings]]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Variable value format ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Variable value format ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>When using a Snowflake model, the Dropdown List Selector stores the variable using the [[Stringified_Value_Format|stringified format]]. When using an in-memory model, the variable values is stored in the json format (https://www.w3schools.com/js/js_json_intro.asp). The reason for the different behavior is that the stringified format is more versatile, so it was taken into use for Snowflake (which was implemented after the original in-memory). The [[Chart_Linked_Settings|linked settings]] in charts by default use the stringified format, so when working with in-memory models, you need to change the ''valueFormat'' parameter in the linked settings.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>When using a Snowflake model, the Dropdown List Selector stores the variable using the [[Stringified_Value_Format|stringified format]]. When using an in-memory model, the variable values is stored in the json format (https://www.w3schools.com/js/js_json_intro.asp). The reason for the different behavior is that the stringified format is more versatile, so it was taken into use for Snowflake (which was implemented after the original in-memory). The [[Chart_Linked_Settings|linked settings]] in charts by default use the stringified format, so when working with in-memory models, you need to change the ''valueFormat'' parameter in the linked settings.</div></td></tr>
</table>Ollvihehttps://wiki.onqpr.com/pa/index.php?title=Dropdown_List_Selector&diff=23943&oldid=prevOllvihe: /* Dropdown List Selector settings */2023-12-11T20:05:49Z<p><span dir="auto"><span class="autocomment">Dropdown List Selector settings</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 20:05, 11 December 2023</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l17">Line 17:</td>
<td colspan="2" class="diff-lineno">Line 17:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Dropdown List Selector settings ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Dropdown List Selector settings ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Dropdown List Selector has the following settings:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Dropdown List Selector has the following settings:</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''Variable name''': Name of the variable that is linked to this dropdown list. When user makes a selection in the dropdown list, the selection is stored to the variable.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''Title''': Explaining title (label) for the dropdown list that is visible in the dashboard. If no title is defined, an automatic title is derived based on the chosen ''List items''.</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Analyzed objects''': Types of process mining objects where the ''List items'' are calculated from. Based on this selection, there are different options available for the ''List items'' and ''1. measure''. The Analyzed objects selection works similarly as the [[QPR_ProcessAnalyzer_Chart#Analyzed_Data|same selection in charts]].</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Analyzed objects''': Types of process mining objects where the ''List items'' are calculated from. Based on this selection, there are different options available for the ''List items'' and ''1. measure''. The Analyzed objects selection works similarly as the [[QPR_ProcessAnalyzer_Chart#Analyzed_Data|same selection in charts]].</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''List items''': Select what kind of items the dropdown list is showing. There are variety of options to choose from, and the options depend on what has been selected as the ''Analyzed objects''. This selection is similar to the [[QPR_ProcessAnalyzer_Chart#Selecting_Measures.2C_Dimensions_and_Columns|dimension selection in charts]].</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Sorting''': Defines a column based on which items are sorted in the list.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Sorting''': Defines a column based on which items are sorted in the list.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Maximum rows''': Maximum number of items shown by the list. This setting can be used if desired to show only the most relevant items. Listing more than thousands of items may cause the list to work very slowly, so showing lot of items, consider what's the practical maximum from the performance point of view.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Maximum rows''': Maximum number of items shown by the list. This setting can be used if desired to show only the most relevant items. Listing more than thousands of items may cause the list to work very slowly, so showing lot of items, consider what's the practical maximum from the performance point of view.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">* '''Title''': Explaining title (label) for the dropdown list that is visible in the dashboard. If no title is defined, an automatic title is derived based on the chosen ''List items''.</del></div></td><td colspan="2" class="diff-side-added"></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">* '''Variable name''': Name of the variable that is linked to this dropdown list. When user makes a selection in the dropdown list, the selection is stored to the variable.</del></div></td><td colspan="2" class="diff-side-added"></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''1. measure''': The dropdown list can optionally show aggregated/summarized information for each of the shown item. When the first measure is selected, possibility to define a second measure appears. The measures work similarly as [[QPR_ProcessAnalyzer_Chart#Selecting_Measures.2C_Dimensions_and_Columns|measures in charts]].</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''1. measure''': The dropdown list can optionally show aggregated/summarized information for each of the shown item. When the first measure is selected, possibility to define a second measure appears. The measures work similarly as [[QPR_ProcessAnalyzer_Chart#Selecting_Measures.2C_Dimensions_and_Columns|measures in charts]].</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* '''<del style="font-weight: bold; text-decoration: none;">List items</del>''': <del style="font-weight: bold; text-decoration: none;">Select what kind of items the dropdown list is showing. There </del>are <del style="font-weight: bold; text-decoration: none;">variety of options </del>to <del style="font-weight: bold; text-decoration: none;">choose from, and </del>the <del style="font-weight: bold; text-decoration: none;">options depend on what has been selected as </del>the ''<del style="font-weight: bold; text-decoration: none;">Analyzed objects</del>'<del style="font-weight: bold; text-decoration: none;">'. This selection is similar to the </del>[[<del style="font-weight: bold; text-decoration: none;">QPR_ProcessAnalyzer_Chart#Selecting_Measures.2C_Dimensions_and_Columns</del>|<del style="font-weight: bold; text-decoration: none;">dimension selection in charts</del>]].</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* '''<ins style="font-weight: bold; text-decoration: none;">Follow dashboard filters''': </ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''Chart filter</ins>''': <ins style="font-weight: bold; text-decoration: none;">Filter rules that </ins>are <ins style="font-weight: bold; text-decoration: none;">applied </ins>to the <ins style="font-weight: bold; text-decoration: none;">model when getting </ins>the <ins style="font-weight: bold; text-decoration: none;">list items.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* </ins>'''[[<ins style="font-weight: bold; text-decoration: none;">Chart_Linked_Settings</ins>|<ins style="font-weight: bold; text-decoration: none;">Linked settings</ins>]]<ins style="font-weight: bold; text-decoration: none;">'''</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''Model''': Model to which the query is made to get the list items</ins>.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* In addition, there are the same [[QPR_ProcessAnalyzer_Chart#Layout_Settings|layout settings]] available as in charts.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* In addition, there are the same [[QPR_ProcessAnalyzer_Chart#Layout_Settings|layout settings]] available as in charts.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Variable value format ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Variable value format ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>When using a Snowflake model, the Dropdown List Selector stores the variable using the [[Stringified_Value_Format|stringified format]]. When using an in-memory model, the variable values is stored in the json format (https://www.w3schools.com/js/js_json_intro.asp). The reason for the different behavior is that the stringified format is more versatile, so it was taken into use for Snowflake (which was implemented after the original in-memory). The [[Chart_Linked_Settings|linked settings]] in charts by default use the stringified format, so when working with in-memory models, you need to change the ''valueFormat'' parameter in the linked settings.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>When using a Snowflake model, the Dropdown List Selector stores the variable using the [[Stringified_Value_Format|stringified format]]. When using an in-memory model, the variable values is stored in the json format (https://www.w3schools.com/js/js_json_intro.asp). The reason for the different behavior is that the stringified format is more versatile, so it was taken into use for Snowflake (which was implemented after the original in-memory). The [[Chart_Linked_Settings|linked settings]] in charts by default use the stringified format, so when working with in-memory models, you need to change the ''valueFormat'' parameter in the linked settings.</div></td></tr>
</table>Ollvihehttps://wiki.onqpr.com/pa/index.php?title=Dropdown_List_Selector&diff=23844&oldid=prevOllvihe at 17:24, 18 November 20232023-11-18T17:24:00Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:24, 18 November 2023</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''Dropdown List Selector''' enables dynamic behavior to dashboards by allowing users to make selections that affect charts and other components in the dashboard. Thus, the Dropdown List Selector can be used to set parameters for the calculations in charts. The Dropdown List Selector is usual dropdown list where user can select a value from a list of predefined values.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''Dropdown List Selector''' enables dynamic behavior to dashboards by allowing users to make selections that affect charts and other components in the dashboard. Thus, the Dropdown List Selector can be used to set parameters for the calculations in charts. The Dropdown List Selector is usual dropdown list where user can select a value from a list of predefined values.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The dropdown list is linked to other components of the dashboard using variables: The selected value is stored to a variable, which is used by the other components. To make the behavior work, the variable needs to be configured both to the dropdown list and the charts using it. For charts, variables are bound using either [[<del style="font-weight: bold; text-decoration: none;">QPR_ProcessAnalyzer_Chart#Variable_mappings</del>|<del style="font-weight: bold; text-decoration: none;">variable mappings</del>]] or directly using tags in custom expressions (e.g. ''<#tagName>'').</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The dropdown list is linked to other components of the dashboard using variables: The selected value is stored to a variable, which is used by the other components. To make the behavior work, the variable needs to be configured both to the dropdown list and the charts using it. For charts, variables are bound using either [[<ins style="font-weight: bold; text-decoration: none;">Chart_Linked_Settings</ins>|<ins style="font-weight: bold; text-decoration: none;">linked settings</ins>]] or directly using tags in custom expressions (e.g. ''<#tagName>'').</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The Dropdown List Selector can be configured flexibly based on any data in the model, and the contents of the list updates automatically when the model data changes. Note that the Dropdown List Selector is not linked to the filters of the dashboard (for filtering, use the ''Case attribute filter'' or ''Event type filter'' components).</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The Dropdown List Selector can be configured flexibly based on any data in the model, and the contents of the list updates automatically when the model data changes. Note that the Dropdown List Selector is not linked to the filters of the dashboard (for filtering, use the ''Case attribute filter'' or ''Event type filter'' components).</div></td></tr>
</table>Ollvihehttps://wiki.onqpr.com/pa/index.php?title=Dropdown_List_Selector&diff=23843&oldid=prevOllvihe: /* Variable value format */2023-11-18T17:22:44Z<p><span dir="auto"><span class="autocomment">Variable value format</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:22, 18 November 2023</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l27">Line 27:</td>
<td colspan="2" class="diff-lineno">Line 27:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Variable value format ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Variable value format ==</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>When using a Snowflake model, the Dropdown List Selector stores the <del style="font-weight: bold; text-decoration: none;">variables </del>using the [[Stringified_Value_Format|stringified format]]. When using an in-memory model, the variable values is stored in the json format (https://www.w3schools.com/js/js_json_intro.asp). The reason for the different behavior is that the stringified format is more versatile, so it was taken into use for <del style="font-weight: bold; text-decoration: none;">the </del>Snowflake (<del style="font-weight: bold; text-decoration: none;">that </del>was implemented after the original in-memory).</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>When using a Snowflake model, the Dropdown List Selector stores the <ins style="font-weight: bold; text-decoration: none;">variable </ins>using the [[Stringified_Value_Format|stringified format]]. When using an in-memory model, the variable values is stored in the json format (https://www.w3schools.com/js/js_json_intro.asp). The reason for the different behavior is that the stringified format is more versatile, so it was taken into use for Snowflake (<ins style="font-weight: bold; text-decoration: none;">which </ins>was implemented after the original in-memory). The <ins style="font-weight: bold; text-decoration: none;">[[Chart_Linked_Settings|</ins>linked settings<ins style="font-weight: bold; text-decoration: none;">]] in charts </ins>by default use the stringified format, so when working with in-memory models, you need to <ins style="font-weight: bold; text-decoration: none;">change </ins>the ''valueFormat'' parameter in the linked settings.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td colspan="2" class="diff-side-added"></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The linked settings by default use the stringified format, so when working with in-memory models, you need to <del style="font-weight: bold; text-decoration: none;">use </del>the ''valueFormat'' parameter in the linked settings.</div></td><td colspan="2" class="diff-side-added"></td></tr>
</table>Ollvihehttps://wiki.onqpr.com/pa/index.php?title=Dropdown_List_Selector&diff=23842&oldid=prevOllvihe at 17:21, 18 November 20232023-11-18T17:21:13Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:21, 18 November 2023</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l3">Line 3:</td>
<td colspan="2" class="diff-lineno">Line 3:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The dropdown list is linked to other components of the dashboard using variables: The selected value is stored to a variable, which is used by the other components. To make the behavior work, the variable needs to be configured both to the dropdown list and the charts using it. For charts, variables are bound using either [[QPR_ProcessAnalyzer_Chart#Variable_mappings|variable mappings]] or directly using tags in custom expressions (e.g. ''<#tagName>'').</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The dropdown list is linked to other components of the dashboard using variables: The selected value is stored to a variable, which is used by the other components. To make the behavior work, the variable needs to be configured both to the dropdown list and the charts using it. For charts, variables are bound using either [[QPR_ProcessAnalyzer_Chart#Variable_mappings|variable mappings]] or directly using tags in custom expressions (e.g. ''<#tagName>'').</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The Dropdown List Selector can be configured flexibly based on any data in the model, and the contents of the list updates automatically when the model data changes. Note that the Dropdown List Selector is not <del style="font-weight: bold; text-decoration: none;">directly related </del>to the filters of the dashboard (for filtering, use the ''Case attribute filter'' or ''Event type filter'' components).</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The Dropdown List Selector can be configured flexibly based on any data in the model, and the contents of the list updates automatically when the model data changes. Note that the Dropdown List Selector is not <ins style="font-weight: bold; text-decoration: none;">linked </ins>to the filters of the dashboard (for filtering, use the ''Case attribute filter'' or ''Event type filter'' components).</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Add Dropdown List Selector to dashboard ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Add Dropdown List Selector to dashboard ==</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l25">Line 25:</td>
<td colspan="2" class="diff-lineno">Line 25:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''List items''': Select what kind of items the dropdown list is showing. There are variety of options to choose from, and the options depend on what has been selected as the ''Analyzed objects''. This selection is similar to the [[QPR_ProcessAnalyzer_Chart#Selecting_Measures.2C_Dimensions_and_Columns|dimension selection in charts]].</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''List items''': Select what kind of items the dropdown list is showing. There are variety of options to choose from, and the options depend on what has been selected as the ''Analyzed objects''. This selection is similar to the [[QPR_ProcessAnalyzer_Chart#Selecting_Measures.2C_Dimensions_and_Columns|dimension selection in charts]].</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* In addition, there are the same [[QPR_ProcessAnalyzer_Chart#Layout_Settings|layout settings]] available as in charts.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* In addition, there are the same [[QPR_ProcessAnalyzer_Chart#Layout_Settings|layout settings]] available as in charts.</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">== Variable value format ==</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">When using a Snowflake model, the Dropdown List Selector stores the variables using the [[Stringified_Value_Format|stringified format]]. When using an in-memory model, the variable values is stored in the json format (https://www.w3schools.com/js/js_json_intro.asp). The reason for the different behavior is that the stringified format is more versatile, so it was taken into use for the Snowflake (that was implemented after the original in-memory).</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">The linked settings by default use the stringified format, so when working with in-memory models, you need to use the ''valueFormat'' parameter in the linked settings.</ins></div></td></tr>
</table>Ollvihehttps://wiki.onqpr.com/pa/index.php?title=Dropdown_List_Selector&diff=23838&oldid=prevOllvihe: /* Add Dropdown List Selector to dashboard */2023-11-18T17:00:12Z<p><span dir="auto"><span class="autocomment">Add Dropdown List Selector to dashboard</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:00, 18 November 2023</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l6">Line 6:</td>
<td colspan="2" class="diff-lineno">Line 6:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Add Dropdown List Selector to dashboard ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Add Dropdown List Selector to dashboard ==</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">The </del>Dropdown List Selector is added to <del style="font-weight: bold; text-decoration: none;">a </del>dashboard by activating the [[QPR_ProcessAnalyzer_Dashboard_Designer#Editing_Dashboards|Add component mode]] and clicking the Dropdown List Selector in the tool palette. Mandatory settings <del style="font-weight: bold; text-decoration: none;">for the Dropdown List Selector </del>are ''Variable name'' and ''List items'' for the Dropdown List Selector to <del style="font-weight: bold; text-decoration: none;">be shown</del>. When adding the Dropdown List Selector, also the linked variable needs to be defined to the dashboard as follows:</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Dropdown List Selector is added to dashboard by activating the [[QPR_ProcessAnalyzer_Dashboard_Designer#Editing_Dashboards|Add component mode]] and clicking the <ins style="font-weight: bold; text-decoration: none;">''</ins>Dropdown List Selector<ins style="font-weight: bold; text-decoration: none;">'' </ins>in the tool palette. Mandatory settings are ''Variable name'' and ''List items'' for the Dropdown List Selector to <ins style="font-weight: bold; text-decoration: none;">show</ins>. When adding the Dropdown List Selector, also the linked variable needs to be defined to the dashboard as follows:</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># When in dashboard designer in the [[QPR_ProcessAnalyzer_Dashboard_Designer#Editing_Dashboards|Edit mode]], click the dots menu on top right and click '''Dashboard Properties'''.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># When in dashboard designer in the [[QPR_ProcessAnalyzer_Dashboard_Designer#Editing_Dashboards|Edit mode]], click the dots menu on top right and click '''Dashboard Properties'''.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Open the '''Variables''' tab.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># Open the '''Variables''' tab.</div></td></tr>
</table>Ollvihehttps://wiki.onqpr.com/pa/index.php?title=Dropdown_List_Selector&diff=23837&oldid=prevOllvihe: /* Dropdown List Selector settings */2023-11-18T16:58:26Z<p><span dir="auto"><span class="autocomment">Dropdown List Selector settings</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:58, 18 November 2023</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l22">Line 22:</td>
<td colspan="2" class="diff-lineno">Line 22:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Title''': Explaining title (label) for the dropdown list that is visible in the dashboard. If no title is defined, an automatic title is derived based on the chosen ''List items''.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Title''': Explaining title (label) for the dropdown list that is visible in the dashboard. If no title is defined, an automatic title is derived based on the chosen ''List items''.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Variable name''': Name of the variable that is linked to this dropdown list. When user makes a selection in the dropdown list, the selection is stored to the variable.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Variable name''': Name of the variable that is linked to this dropdown list. When user makes a selection in the dropdown list, the selection is stored to the variable.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* '''1. measure''': The dropdown list can optionally show aggregated/summarized information for each of the shown item <del style="font-weight: bold; text-decoration: none;">in parenthesis</del>. When the first measure is selected, possibility to define a second measure appears. The measures work similarly as [[QPR_ProcessAnalyzer_Chart#Selecting_Measures.2C_Dimensions_and_Columns|measures in charts]].</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* '''1. measure''': The dropdown list can optionally show aggregated/summarized information for each of the shown item. When the first measure is selected, possibility to define a second measure appears. The measures work similarly as [[QPR_ProcessAnalyzer_Chart#Selecting_Measures.2C_Dimensions_and_Columns|measures in charts]].</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''List items''': Select what kind of items the dropdown list is showing. There are variety of options to choose from, and the options depend on what has been selected as the ''Analyzed objects''. This selection is similar to the [[QPR_ProcessAnalyzer_Chart#Selecting_Measures.2C_Dimensions_and_Columns|dimension selection in charts]].</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''List items''': Select what kind of items the dropdown list is showing. There are variety of options to choose from, and the options depend on what has been selected as the ''Analyzed objects''. This selection is similar to the [[QPR_ProcessAnalyzer_Chart#Selecting_Measures.2C_Dimensions_and_Columns|dimension selection in charts]].</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* In addition, there are the same [[QPR_ProcessAnalyzer_Chart#Layout_Settings|layout settings]] available as in charts.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* In addition, there are the same [[QPR_ProcessAnalyzer_Chart#Layout_Settings|layout settings]] available as in charts.</div></td></tr>
</table>Ollvihehttps://wiki.onqpr.com/pa/index.php?title=Dropdown_List_Selector&diff=23836&oldid=prevOllvihe: /* Dropdown List Selector settings */2023-11-18T16:57:04Z<p><span dir="auto"><span class="autocomment">Dropdown List Selector settings</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:57, 18 November 2023</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l17">Line 17:</td>
<td colspan="2" class="diff-lineno">Line 17:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Dropdown List Selector settings ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Dropdown List Selector settings ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Dropdown List Selector has the following settings:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Dropdown List Selector has the following settings:</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* '''Analyzed objects''': Types of objects where the ''List items'' are <del style="font-weight: bold; text-decoration: none;">derived</del>. Based on this selection, there are different options available for the ''List items'' and ''1. measure''. The Analyzed objects selection works similarly as the [[QPR_ProcessAnalyzer_Chart#Analyzed_Data|same selection in charts]].</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* '''Analyzed objects''': Types of <ins style="font-weight: bold; text-decoration: none;">process mining </ins>objects where the ''List items'' are <ins style="font-weight: bold; text-decoration: none;">calculated from</ins>. Based on this selection, there are different options available for the ''List items'' and ''1. measure''. The Analyzed objects selection works similarly as the [[QPR_ProcessAnalyzer_Chart#Analyzed_Data|same selection in charts]].</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* '''Sorting''': Defines a column based on which items are sorted in the list<del style="font-weight: bold; text-decoration: none;">. The ''1. dimension'' means sorting based on the ''List items''</del>.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* '''Sorting''': Defines a column based on which items are sorted in the list.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* '''Maximum rows''': Maximum number of items shown by the list. This setting can be used to show only the most <del style="font-weight: bold; text-decoration: none;">important </del>items. <del style="font-weight: bold; text-decoration: none;">Note that </del>the list <del style="font-weight: bold; text-decoration: none;">can smoothly show maximum of couple of thousand </del>of items, <del style="font-weight: bold; text-decoration: none;">so </del>the maximum <del style="font-weight: bold; text-decoration: none;">rows limitation is also needed </del>from the <del style="font-weight: bold; text-decoration: none;">dashboard </del>performance <del style="font-weight: bold; text-decoration: none;">viewpoint</del>.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* '''Maximum rows''': Maximum number of items shown by the list. This setting can be used <ins style="font-weight: bold; text-decoration: none;">if desired </ins>to show only the most <ins style="font-weight: bold; text-decoration: none;">relevant </ins>items. <ins style="font-weight: bold; text-decoration: none;">Listing more than thousands of items may cause </ins>the list <ins style="font-weight: bold; text-decoration: none;">to work very slowly, so showing lot </ins>of items, <ins style="font-weight: bold; text-decoration: none;">consider what's </ins>the <ins style="font-weight: bold; text-decoration: none;">practical </ins>maximum from the performance <ins style="font-weight: bold; text-decoration: none;">point of view</ins>.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Title''': Explaining title (label) for the dropdown list that is visible in the dashboard. If no title is defined, an automatic title is derived based on the chosen ''List items''.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Title''': Explaining title (label) for the dropdown list that is visible in the dashboard. If no title is defined, an automatic title is derived based on the chosen ''List items''.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Variable name''': Name of the variable that is linked to this dropdown list. When user makes a selection in the dropdown list, the selection is stored to the variable.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Variable name''': Name of the variable that is linked to this dropdown list. When user makes a selection in the dropdown list, the selection is stored to the variable.</div></td></tr>
</table>Ollvihe