Hi All, need your help. How can we display percentage contribution in the bar charts in SAS VA? eg. top 10% contributor 10-50% contributor and lest then 50% contributors with different color in single bar chart and data is given to us is without percentage calculation.
Create a new calculated item that is a percentage value using the new calculated data item window as described at SAS(R) Visual Analytics 6.4: User's Guide - Working with Calculated Data Items in Reports
Once you have the data item available then drag a new bar chart object into the workspace area and then click on the Display Rules tab on the left pane. Here, you want to set up a Graph-Level Display Rule as described at SAS(R) Visual Analytics 6.4: User's Guide - Adding Graph-Level Display Rule to use in the bar chart.
As you would normally calculate a percentage... the value of the data item divided by the sum of data item which is an aggregated measure. Once you do this you will get a decimal value and then you can use a percent format to have it as a percentage.
For example: if your data item is X then
X / Sum ForAll(X)
I think you may need to create a new Aggregated Measure rather than so that the special Sum ForAll() function is available as described at SAS(R) Visual Analytics 6.4: User's Guide - Aggregated Measure
I am attaching the data and I want top 10%, 10-50% and 50% above pending amount contributor. I want to display all these percentage yearwise, monthwise with their amount and color coding. This is just a sample data we have to do it for huge data.
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.