How to count the group percentage in Gchart

ursula — Wed, 18 Sep 2013 20:31:57 GMT

Hi there,

I wonder if somebody can help me to figure it out of how to code the group percentage in Gchart.

I have 3 groups in one Gchart. for example: first group is US (female , male)

second group is AU (female, male)

Thirth group is Hawaii (female, male)

I want to code the female and male percentage for US, AU and Hawaii individually, so each group has the total percent of 100%

- percent female and male in US. for example: 60% female and 40% male.

- how many percent female and male in AU. for example 25% female and 75% male

- how many percent female and male in Hawaii. for example 50% female and % male

when I created a Gchart for the 3 group, I got the total 100% for the 3 groups (for example: US (female=10% male=20%), AU(female=20% male=30%) Hawaii(female=10% male=10%)),this is not what I expected.

Please help me to solve the problem.

Thank you,

Re: How to count the group percentage in Gchart

AncaTilea — Wed, 18 Sep 2013 20:40:48 GMT

So,

I believe you will need your group variable to be the US,AU,HAWAII, and then have gender as a subgroup.

Re: How to count the group percentage in Gchart

ballardw — Wed, 18 Sep 2013 22:06:46 GMT

It is helpful to post the code you used when asking questions as you could be very close and only need minor changes or sometimes the data needs to preprocessed.

topic Re: How to count the group percentage in Gchart in Graphics Programming

How to count the group percentage in Gchart

Re: How to count the group percentage in Gchart

Re: How to count the group percentage in Gchart