Forum Discussion

301066's avatar
301066
Frequent Visitor
3 years ago

Filtering a bubble map using latitude and longitude from another visualization

I have a bubble map using latitude and longitude and a bar chart with city. When I select the city in the bar chart the map displays the total for the city in one bubble and not, as required, the ind...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi 301066 ,

 

Accoridng to your statement, I think you need two tables one is city for bar chart and another is location in city group for map chart.

Table1:

Table2:

Relationship:

When I select City1 in bar chart, map will only show the locations in selected city.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

301066's avatar
301066
Frequent Visitor
3 years ago

Hi Rico

Thanks for your help on this.

I created the two additional tables and copied the relationship you suggested:

but the map bubbles still default to the total for the city, not the individual locations. I only have latitude and longitude in the map and only have city in the chart.

The table above the chart filters down to the individual accounts but the map doesn't.

Any ideas?

Thanks