Documentation Controls and Variables

FAQs about Controls and Variables

The Range Input control allows users to dynamically filter charts based on a numeric range.

Relative Date Variables allow you to specify a dynamic date which can be used wherever you would enter a fixed date value.

Date Sliders are useful for analyzing periods of time. Additional dimensionality can be added by putting a measure into your Date Slider.

To fit your needs or to improve performance, you can connect your Dashboard Controls in the Pipeline rather than in the Query itself.

Filter your Dropdown's results according to the selection made in a connected Dropdown.

Exclude default Date Bucket options by creating your own using a Dropdown.

Add custom data which isn't located in your database to your charts and variables to further customize your dashboards.

Edit the WHERE statement in SQL Mode in order for your Text Input Controls to allow a list of search terms to filter your charts.

When no Dropdown values are selected, filter your chart with all values in your Dropdown by default.

To use the Show All setting for multi-select Dropdowns connected in the Pipeline, use this alternate method to implement that logic.

When setting a Dropdown control to Show All on the empty state, the connected charts won't be filtered when no Dropdown selections are made.

Use a CASE statement in a Dropdown Control to customize the results appearing in the list.

To create a dropdown with a key value pair, edit your dropdown to add a second column into dimension; this column will be the display values.