% Distribution

Sun, 30 Jun 2013 10:47:26 GMT

Hi all,

i am having trouble with a bar chart.

My app provides data of a survey, where companies answer a set of questions.

I have classified each answer as to belong to the category - "Very Good", "Good" or "Bad".

Companies come from 3 different countries "USA", "KANADA" and "ITALY".

In a bar chart i want to show for each Country the number of answers that belong to either "Very Good", "Good" or "Bad" as a % value.

The total % should sum up to 100%.

I tried using Country and Category as dimensions and

sum(answers) / sum(total answers)

but the total of the %es only sums up to 100% if i select one country in the chart.

Any idea how to solve this ?

Thanks a lot!

Re: % Distribution

swuehl — Sun, 30 Jun 2013 11:48:30 GMT

Could you post a small sample so that we can look into your settings and data model?

Gysbert_Wassenaar — Sun, 30 Jun 2013 13:21:43 GMT

Try sum(answers) / sum(total <Country> answers)