Create a Dropdown

Click Add Control from the dashboard sidebar menu and select Dropdown. You’ll be redirected to the Data Explorer. Find the column you want to use for your category and drag it to the Dimensions field. The values in that column will populate a dropdown menu, which you can use to filter your charts.

Data Explorer

Key-value pair dropdowns

You can drag a second Dimension into your categorical dropdown to display one value but filter by another. Check out our tutorial on key value pairs in a categorical dropdown.

  • Multiple values: check this checkbox to allow filtering by multiple values at once. If selecting multiple values, be sure your connected chart’s filter is “is one of” and not “equals” or “like”.

  • Empty state: When no values are selected in the dropdown, you can either Show all rows in the attached charts or Show none.

  • Default values: check this checkbox to set custom filter value(s) on load.

Change the aggregation

Connect a Dropdown to a chart

Open the chart you’d like to connect to your Dropdown in the Data Explorer. Drag the column you want to filter your dataset on into the Filters section, select the filter type, and select your variable name.

A couple things to keep in mind:

  • your Dropdown must have the same data type as the column you’re filtering on
  • your filter type must match the type of Dropdown you’re using. If you’ve left Multiple unchecked in the Dropdown’s settings, make sure you don’t use filter type ‘is one of’, for example.

Add a Date Bucket Selector