BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
AnjaliNair
Calcite | Level 5

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. 

 

date.png

 

NoRole.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Can someone suggest me what should be done here?

 

Thanks in Advance,

Anjali

1 ACCEPTED SOLUTION

Accepted Solutions
FalkoSchulz
SAS Employee

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

View solution in original post

5 REPLIES 5
FalkoSchulz
SAS Employee

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
Calcite | Level 5

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
SAS Employee

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
Calcite | Level 5

Hello Falko,

 

So we are using the below sample data:

 

CountrySentiment_labelSentiment
IndiaNegative0
IndiaPositive1
IndiaPositive1

 

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
SAS Employee

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

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 1402 views
  • 0 likes
  • 2 in conversation