As stated above, I created a form that is basically a survey that users fill out. One question asks 1-10 how satisfied? I sum up all these forms into the results we received for the month. So for the entire month: User 1 = 8, User 2 = 8, User 3 = 9.
How do I create a graph bar chart in QuickBase that shows 66% (% Y axis) chose #8 while 33% chose 9? I can create formula fields within the tables first before creating the graph. However, the Y axis sums or averages?
It has to be a bar graph so managers can see the spread of answers not a pie chart.