Format Tab
Chart Level Filters
Format Tab
Chart Level Filters
Chart level filters allow you to choose the categories that customers will be able to pick from to view charts.
Adding the Chart Level Filter
In a chart that supports color categorization, you can drag multiple columns into the color category. If more than one color exists, a dropdown will appear on the respective chart that the customer can use to switch between views.
You can also format the dropdown to appear either in the top right corner or below the title of the chart. The default placement is top right corner.
Variable Usage
The selected item in the dropdown will be saved in a variable and can be used like any other variables across the dashboard.
In the SQL query, use the following syntax
WHERE 1=1
[[AND column_1 = {{<insert dataPanelId>.EXPLO_COLOR_CATEGORY}}]]