topic Re: 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. in SAS Visual Analytics

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.

puneetwadhwa85 — Wed, 07 Jan 2015 05:42:24 GMT

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.

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

MichelleHomes — Wed, 07 Jan 2015 06:19:34 GMT

Hi,

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.

Kind Regards,

Michelle

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

puneetwadhwa85 — Wed, 07 Jan 2015 06:35:51 GMT

Thank You Michelle. But how to convert data into percentage as there is no % conversion or rank % in SAS VA.

Regards

Puneet

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

MichelleHomes — Wed, 07 Jan 2015 06:54:53 GMT

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

Kind Regards,

Michelle

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

skillman — Thu, 08 Jan 2015 14:41:50 GMT

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.

Thanks,

-shawn

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

puneetwadhwa85 — Fri, 09 Jan 2015 09:19:55 GMT

Hi Shawn,

Will share the data soon.

Regards

Puneet

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

puneetwadhwa85 — Fri, 09 Jan 2015 09:40:24 GMT

Hi Shawn,

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.

Regards

Puneet