Hi, I saw a tutorial for Dashboard showing how you can click on a wheel of one pie chart to filter data in another (pie) chart. I am having trouble figuring out how to do that in experience builder. I was going to do this in dashboard instead, but I am interested in the query functionality in experience builder (that I can't figure out in dashboard).
For example, I am building an experience builder to spatially visualize our client base. I'd like to be able to:
- query for a specific geographic location (eg., Canada)
- from that query, bring up a:
- bar chart of revenue x regions (eg., provinces)
- pie chart of counts for different types of clients
3. Ideally, then I could click on a slice of the pie chart and it would then filter the bar chart to show only revenue for that specific type of client in those geographic regions (or vice versa)
So far the first two steps are working well!
But I am unable to action the pie chart to the bar chart or vice versa to complete the last step as I don't want to action a particular map, and when I try to use the framework to set the trigger/action data appropriately, I get stuck since they now don't have common fields (that work, it doesn't work when I use OBJECTID for both).
Is this possible or are there any workarounds ? And/or is there a query functionality in dashboard that I haven't figured out? Thanks so much!