Hi everyone,
I recently started using AI/BI dashboard and I'm struggling with this glitch in the map. The visual was generated without any issues but the cross-filtering of the map for example, if I click on a county, the rest of the chart values change, but there's always one county that doesn't work at all. Sometimes the county changes, but there's always one that doesn't work. If I use actual filter widget, the county that didn't work on the map works fine. I tried many ways to debug, they didn't work.
- Checked the underlying data and the data exists - no issue here
- Deleted and created new map, the issue still persisted
- Created new dashboard and map visual, the issue still persisted
For more context, the data is medical condition information where one user have multiple health conditions. The map was colored based on count_distinct of userid - an aggregated field. I tried using no aggregation, the map county cross-filter worked fine but the rest of the chart produced incorrect results. I don't know how to resolve this issue and if anyone encountered and resolved similar issue, please let me know.
