Documentation Controls and Variables

FAQs about Controls and Variables

We try to answer all the most frequently asked questions on controls and variables here, but if you have a fresh one, send us a note at or open a chat below. We’re always looking to add more!

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.

Filter your Dropdown's results according to the selection made in a connected 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 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.