Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Traffic light column in a SAS VA cross table or list table

Reply
New Contributor
Posts: 3

Traffic light column in a SAS VA cross table or list table

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 

SAS Super FREQ
Posts: 586

Re: Traffic light column in a SAS VA cross table or list table

[ Edited ]

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...

 

Occasional Contributor
Posts: 15

Re: Traffic light column in a SAS VA cross table or list table

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

New Contributor
Posts: 3

Re: Traffic light column in a SAS VA cross table or list table

Hi Marylin and Glaubert,

I'll give these hints a try tomorrow.

Thank you very much

Robert

New Contributor
Posts: 3

Re: Traffic light column in a SAS VA cross table or list table

Hi All,

This was a perfect help.

Thank you very much

Robert

Ask a Question
Discussion stats
  • 4 replies
  • 289 views
  • 2 likes
  • 3 in conversation