Having issues with a Pie Chart, so im bringing it to the guru’s.
Input is a series of 18 questions. All but 1 are Yes or No, the odd ball is a Enum with 3 options.
What Im trying to do is this…
- 1 Pie Chart for 1 user data
- user puts in multiple entries
- I want to total the entries and provide each question in the graph as a percentage.
Example
Joe made 10 entries so far
Question 1 20% of the responses were YES
Question 2 5% of the responses were YES
Question 3 95% of the responses were YES
The math is pretty simple: Q1Percentage = count of yes / Total entries
Same for each of the 18 …
Then graph the Q#Percentage fields …
However, this plan does not seem to be working, and any help would be greatly appreciated.
Dave