BookmarkSubscribeRSS Feed
GrumpyEthel
Fluorite | Level 6

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. 

 

GrumpyEthel_0-1745308324664.png

GrumpyEthel_1-1745308344597.png

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

GrumpyEthel_2-1745308902154.png

Error message is :

GrumpyEthel_3-1745308933411.png

 




2 REPLIES 2
Madelyn_SAS
SAS Super FREQ

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

GrumpyEthel
Fluorite | Level 6

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. 

 

GrumpyEthel_0-1745484447964.png

 

the Aggregated measure i have was : 

 

GrumpyEthel_1-1745484518694.png

how do i work around this? 

 

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

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
  • 2 replies
  • 417 views
  • 1 like
  • 2 in conversation