Use controls for interactive filtering

Controls are interactive elements that can filter or change the way data looks on your dashboard.

Setting up a control is a two-part process. First, you’ll create the control. Next, you’ll connect the control to one or more charts in either a query or another Visual SQL step.

When you change the selected values in a control, the connected charts will filter their data using those values.

Control types
View the types of controls you can use to filter charts on your dashboard.
Set up a “Calendar” control
Use a “Calendar” control to filter connected charts on a specific date or date range.
Set up a “Date bucket” control
Use a “Date bucket” control to change the time grouping for connected charts.
Set up a “Date slider” control
Use a “Date slider” control to focus on a specific date range for a particular metric.
Set up a “Dropdown” control
Use a “Dropdown” control to display query results as a list used to filter multiple charts on a dashboard.
Set up a “Hidden variable” control
Use a “Hidden variable” control to set filter values without a visible control on the dashboard.
Set up a “Range input” control
Use a “Range input” control to filter data based on a selected numeric range.
Set up a “Text input” control
Use a “Text input” control to filter charts for exact or partial string matches.
What is the control editor?
Learn how to create controls using the control editor.
Manage controls
Edit, reset, or delete controls on a dashboard.
Connect a control outside of a query in Visual SQL
Improve chart performance by referencing a control outside of a query in Visual SQL.
Use charts as controls
Drill down into the data of a chart and filter the current dashboard or a different dashboard accordingly.
Use wildcards in a “Text input” control
Use SQL mode to use partial string matching for “Text input” controls.

Was this helpful?

It wasn't accurate

It wasn't clear

It wasn't relevant

Use controls for interactive filtering

Additional Help