How to dynamically switch field on a stacked bar chart

[thaisgbraga]

I’m new to Omni and i need to create a dimension and a control (or maybe a parameter) so users can choose with which column they want to see a bar chart stacked with color. For example I have total amount sales and i want to see it whether by sales team, OR state, OR country, OR another dimension column i have in my workbook. How can we do this in Omni?

[James]

Hi! You can use a field switcher control to swap out fields in a query

Dynamically displaying tile fields with controls - Omni Docs

You’d add it to a dashboard from Add>Control>Field switcher and then you can configure which fields switch out for that control.