Well, aggregation needs to happen in this case if you have more than one row for a given location. So in your example - you have 3x rows for India. If you render such data on a geo map - there is only one single data point for India and the data query behind the scenes will try to aggregate the data given the selected aggregation method selected in the data panel. By default it's SUM - but if you get an average here - chances are you have selected AVG for your sentiment data item.    Also, when you add an animation - the aggregation is not only done on location level but also on date level. So if you have more than one row for the same date - aggregation will also apply here.   So in your example - what would be the expected outcome? You mentioned - you would expect two bubbles here but that really would mean a bubble at the same location overlapping each other. Such rendering is forced when you use a categorical data item as color (since we can't aggregate) - but it's not really a good representation of the data and your report consumer may struggle to understand what this means.   Given you are forced to use a numeric data item for animation - you may want to show an average sentiment score here, e.g. 1 as per your example - indicating that overall sentiment was positive. You could also replace zero for the negative sentiment value with -1 and then use SUM as aggregation - giving you an overall sense of whether a location was positive or negative. As mentioned before - you could use display rules to better differentiate between negative and positive sentiment as well. If users need to drill into detail here - you could setup a second visualization (e.g. list table) and enable interaction between the geo map. This way you could show a complete list of all sentiments for a selected location.   Hope this helps. Falko ... View more

Moving the post to the Developers Community as the Coding on SAS Viya Community is being sunset. ... View more

Thank You Falko. It works perfect now. ... View more