I am facing the following issue on SAS Viya VA (8.1): Several IDs are depicted on a geo map based on their coordinates (geographic data items created based on custom coordinates). When I click on a bubble on the map, a table on the left of the map is filtered showing details for the IDs.
But in some cases, two or more IDs' coordinates coincide (which is expected, it is not an error in the source data), so I get one bubble on the map for those. I have the following two questions for this case:
1. When I click on the bubble, the table is filtered but it shows data only for one of the IDs (the one with the MAX(measure). How can I change this so that it shows data for all IDs on the same coordinates?
2. In the same context, as I have used display rules on the map based on the measure, the color of the bubble is defined by the the ID with the MAX(measure). How can I change this so the colour changes based on the MIN(measure)?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.