Create controls using the control editor

The control editor gives you more flexibility when creating Dropdown and Date slider controls. It looks very similar to the chart editor, where you can use Visual SQL to build queries and transform the data further.

Some common use cases for creating Dropdown controls using the control editor include:

• Key-value pair dropdowns - The values in the dropdown correspond to another value in the background, which is what’s used to filter connected charts. For example, you could have a Team dropdown that shows team names, but the corresponding team ID of the selected team is what’s used to filter charts.

• Dependent dropdowns - The values of one dropdown are dependent on the values that are selected from another dropdown. For example, you could have a Project dropdown and a Work type dropdown where the selected projects determine which work types are selectable.

• CASE statements in a dropdown - Customize the values in the dropdown with if-then statements.

• Custom date buckets - Set your own date buckets to choose from if the native Date bucket control doesn’t meet your needs.

The most common use case for creating a Date slider control using the control editor is to add a 2nd dimension to the control. Read more about creating 2D date sliders.