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

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

RHECK — Thu, 09 Nov 2017 08:42:29 GMT

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:

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

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

Madelyn_SAS — Thu, 09 Nov 2017 14:55:26 GMT

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#p03bn86e541na5n1po390njsecp1.htm

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

gcarvalho — Thu, 09 Nov 2017 15:46:15 GMT

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

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

RHECK — Thu, 09 Nov 2017 20:19:23 GMT

Hi Marylin and Glaubert,

I'll give these hints a try tomorrow.

Thank you very much

Robert

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

RHECK — Fri, 10 Nov 2017 09:20:12 GMT

Hi All,

This was a perfect help.

Thank you very much

Robert