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 support@chartio.com 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.

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.

Since you can't connect your multi-select Dropdowns using 'is one of' in the Pipeline, you'll need to use this workaround to implement that same 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.