Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
K
Could you post a small sample so that we can look into your settings and data model?
Try sum(answers) / sum(total <Country> answers)