topic SAS VA - How to add arrows as indicator for adding growth and downgrowth average in SAS Visual Analytics

SAS VA - How to add arrows as indicator for adding growth and downgrowth average

GrumpyEthel — Tue, 22 Apr 2025 08:02:36 GMT

Dear Team,

I am currently working on a dashboard with a data source from a DataMart, i am trying to achieve adding a visual indicator for values with an arrow up and down which will have a rule to be applied. arrow up to be green once value goes up and down arrow with a color red once the values go down, so I could have a much nicer visual approach.

currently my calculations are all in aggragated measure and i could not add the "if else" as i am getting an error :

Error message is :

Re: SAS VA - How to add arrows as indicator for adding growth and downgrowth average

Madelyn_SAS — Tue, 22 Apr 2025 13:47:46 GMT

There are multiple suggestions in a previous thread on this topic, including using display rules. Here is one solution that uses a calculation.

https://communities.sas.com/t5/SAS-Visual-Analytics/Implement-arrow-symbol-in-VA/m-p/765182#M15231

Re: SAS VA - How to add arrows as indicator for adding growth and downgrowth average

GrumpyEthel — Thu, 24 Apr 2025 08:48:53 GMT

Dear Madelyn,

i am getting an error while following the instruction - with below screenshot: saying that an element must be aggregated and cannot be used here.

the Aggregated measure i have was :

how do i work around this?