BookmarkSubscribeRSS Feed
RHECK
Fluorite | Level 6

Hi All,

 

This is my first posting on this community. We are using currently SAS VA 7.3 (in collaboration with SAS Financial Management 5.5) and our users would like to have a tabular Report like this:

 

TrafficLight.PNG

 

The column flag indicates the delta in % between the columns "Ist" and "Plan". I have not been able to find a way so far how to do this.

 

Best regards

 

Robert 

4 REPLIES 4
Madelyn_SAS
SAS Super FREQ

You probably can use a Display Rule of the Gauge type to create this table. One of the options is to replace the value with the icon. See this topic:

http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p03bn86e541na5n1po390...

 

gcarvalho
Obsidian | Level 7

Hi there,

 

You can use the display rules in your table and some other objects. To use on the table, you just need to create a new display rule and select the values or the conditions that you want for each color, you can follow the screenshots bellow.

 

 

I hope it helps!

Best Regards,

Glaubert

 

Screenshot_1.jpgScreenshot_2.jpgScreenshot_3.jpgScreenshot_4.jpg

RHECK
Fluorite | Level 6

Hi Marylin and Glaubert,

I'll give these hints a try tomorrow.

Thank you very much

Robert

RHECK
Fluorite | Level 6

Hi All,

This was a perfect help.

Thank you very much

Robert

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 4 replies
  • 1744 views
  • 5 likes
  • 3 in conversation