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

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.

Reply
Occasional Contributor
Posts: 5

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.

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.

Trusted Advisor
Posts: 1,296

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.

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

Occasional Contributor
Posts: 5

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.

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

Regards

Puneet

Trusted Advisor
Posts: 1,296

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.

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

SAS Employee
Posts: 85

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.

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

Occasional Contributor
Posts: 5

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.

Hi Shawn,

Will share the data soon.

Regards

Puneet

Occasional Contributor
Posts: 5

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.

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

Attachment
Ask a Question
Discussion stats
  • 6 replies
  • 516 views
  • 0 likes
  • 3 in conversation