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 individual locations in the city. How do I get the two visualizations to interact properly?

Need Help

2 Replies

  • 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