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.
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
Copy
Ask AI
WHERE 1=1[[AND column_1 = {{<insert dataPanelId>.EXPLO_COLOR_CATEGORY}}]]