01-07-2015 12:42 AM
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.
01-07-2015 01:19 AM
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.
01-07-2015 01:35 AM
Thank You Michelle. But how to convert data into percentage as there is no % conversion or rank % in SAS VA.
01-07-2015 01:54 AM
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
01-08-2015 09:41 AM
Will you provide a sample of the data that is provided to you? I have developed something similar to this using custom categories. Although I want to see how the data is sourced prior to providing a solution.
01-09-2015 04:19 AM
Will share the data soon.
01-09-2015 04:40 AM