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? 

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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