Content Comparison

...

1. Open the dashboard where you want to add the “Dropdown” control.

2. Select Add control > Dropdown from the dashboard sidebar. This takes you to the control buildereditor, which is similar to the chart buildereditor. You’ll use Visual SQL to create your “Dropdown” control, but instead of a chart preview, you can preview your “Dropdown” control.

3. Add the column you want to use for your category to the “Columns” section of the query. The values in that column will populate the options in the “Dropdown” control.

4. Select Run query. The preview pane will display the control’s settings.

5. Edit the control’s settings as needed. (See next section to learn more about “Dropdown” settings)

6. Select Save to dashboard.

7. Place the newly created “Dropdown” control anywhere on your dashboard.

...

To connect a “Dropdown” control to a chart using a visual mode query:

1. Open the chart builder editor by creating a new chart or editing an existing chart on the dashboard.

2. In the “Filters” section of your visual mode query:

   1. Add the column you want the control to filter. It must have the same data type as your “Dropdown” control.

   2. Select the appropriate filter operator. If you selected Multi-select in your “Dropdown” settings, use is one of.

   3. Select your control’s variable.

3. Select Run query. The result table will update with the new filter applied to the data.

4. Select Save to dashboard to save the chart.

...