StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Say we had a dashboard with an Entity prompt and we wanted to restrict the user's selection to 5 entities or less. We can apply conditions to the dashboard sections that will show/hide a section based on the number of entities selected. So initially we create a dashboard with a prompt section, an analysis section, and an error message section. The backend would look like this:</p> <p><img src="https://i.stack.imgur.com/8ECRV.png" alt="Create dashboard with 3 sections"></p> <p>The frontend would look like this:</p> <p><img src="https://i.stack.imgur.com/YQcl3.png" alt="enter image description here"></p> <p>Then we would create a new analysis that includes only the Entity column and we set its filter to "is prompted":</p> <p><img src="https://i.stack.imgur.com/D4QsL.png" alt="Entity condition analysis"></p> <p>Note that "Entity Level 4 Code" is actually the Entity column. We could save this analysis as "Entity Condition". Then on the backend of the dashboard we could set section conditions based on this "Entity Condition" analysis. For the Analysis section we would set the condition to:</p> <pre><code>ROWCOUNT('Entity Condition') <= 5 </code></pre> <p><img src="https://i.stack.imgur.com/wDgJW.png" alt="Analysis condition"> <img src="https://i.stack.imgur.com/QxX5R.png" alt="Analysis condition settings"> <img src="https://i.stack.imgur.com/gaomZ.png" alt="enter image description here"></p> <p>For the Error Message section we would create a similar condition except it would be set to:</p> <pre><code>ROWCOUNT('Entity Condition') > 5 </code></pre> <p>This would set the dashboard up so that the Analysis section is only run when the Entity prompt has 5 or less entities selected. If there are more than 5 entities selected the Error Message section is shown:</p> <p><img src="https://i.stack.imgur.com/PkX2i.png" alt="4 entities selected"> <img src="https://i.stack.imgur.com/c0oaa.png" alt="7 entities selected"></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload