topic Re: How to get the percentage of different group within same category in bar chart in SAS Visual Analytics

How to get the percentage of different group within same category in bar chart

Sagdec — Thu, 03 Dec 2015 10:26:12 GMT

Hi,

I am trying to create a bar chart in the report using SAS VA and I want to get the percentage of different group within same category. For example, I have group A, B and C. I use Year as category or the x-axis. I try to get the percentage so that if I add up the percentage for A, B and C in the same year it will be 100%. But currently the percentage will be 100% only when I add up the percentage for all the year.

Can someone help me with it? It is quite urgent.

Thanks!

Re: How to get the percentage of different group within same category in bar chart

Sam_SAS — Thu, 03 Dec 2015 15:37:59 GMT

I'm not sure of a way to get the percentage of a subtotal like this in a bar chart.

For what it's worth, you can create percentage of subtotal for a crosstab.

Re: How to get the percentage of different group within same category in bar chart

TejaSurapaneni — Thu, 03 Dec 2015 17:40:31 GMT

Hello Sagdec,

Use Group by option which is available in 'Roles'.
As per your data., Roles are...

Category : Year
Measure : Some X or Percentage.
Group (by) : Group.

Hope this helps you...

Let me know..

Thanks & Regards,
Teja Surapaneni

Re: How to get the percentage of different group within same category in bar chart

Sam_SAS — Thu, 03 Dec 2015 17:54:37 GMT

Hi Teja,

The trouble is, the percentages are based on the full data and not the subgroup:

There doesn't seem to be an easy way to get these group subtotals in a barchart.

Sam

Re: How to get the percentage of different group within same category in bar chart

Sagdec — Fri, 04 Dec 2015 01:03:44 GMT

Hi Teja, if I put percentage as measure it will show percentage of total not subgroup. But thanks for your reply!

Re: How to get the percentage of different group within same category in bar chart

Sagdec — Fri, 04 Dec 2015 01:04:42 GMT

Haha, thanks Sam. I also got the crosstab one but my boss prefer the bar chart. Thanks for your reply!

Re: How to get the percentage of different group within same category in bar chart

TejaSurapaneni — Fri, 04 Dec 2015 08:01:01 GMT

Hello Sam,

I got it.., I agree with u..

Teja