Error: No data role for animation in Geo Map

[AnjaliNair]

Hi All,

I am trying to provide animation to my Geo Bubble Map in SAS VA 8.3.

I have multiple datetime data item in my data source. But I am not able to add the same for animation role. 

Can someone suggest me what should be done here?

Thanks in Advance,

Anjali

[FalkoSchulz · Accepted solution]

Hi,

Do you have a categorical data item assigned for the color role by any chance? If so - animation is not supported due to the underlying data model. Either remove the data item from the color role or use a numeric data item.

Hope this helps.

Regards, Falko

[AnjaliNair]

Thank you Falko.

I had re placed the sentiment category item(containing Positive and Negative as data values)  for the color with sentiment numeric data item (containing 0 and 1 as data values). But the issue I am facing now is, since the color is given a numeric data item, it is taking a range from 0 to 1.

So how can I avoid this and let the color take only 0 and 1 as the data value or how can I make it possible to use the category data item for color with the animation.

Thanks in Advance.

[FalkoSchulz]

Hi, Have you tried creating a display rule based on your numeric value? You could color values with 0 differently to 1 and achieve a similar outcome.

Hope this helps. Falko

[AnjaliNair]

Hello Falko,

So we are using the below sample data:

Country	Sentiment_label	Sentiment
India	Negative	0
India	Positive	1
India	Positive	1

Expected output is 2 bubbles for India --1 for positive(1) and 1 for negative (0). So if we are using Sentiment_label, i.e. category for the color role or use it in Display rule, we achieve the output as per the expectation but then animation wont be possible. And when we use sentiment (numeric data item) for the color role or display rule, it takes an average value for India and it shows a color between red and green. Basically it doesn't take distinct values, it groups itself for a location.

So, is there any way to have distinct values and not the average or sum of Sentiment. Or is there any other way to achieve the expected output.

Thanks in advance,

Anjali

[FalkoSchulz]

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