% of times numeric field was used. My survey question is 1 to 10. User 1 = 8, User 2 = 8, User 3 = 9. How do I show that 66% said 8 and 33% said 9 in a Bar graph?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

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.

Photo of Lija


  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Mike


  • 50 Points
OK so simplest way is to use the parent child relationship to create a summary of all records and a summary of each value 1-10 you can then create a formula numeric field to calculate the percentage for each answer and do a simple bar chart with with value 1-10 being the x axis and the percentage field as the y axis.  If you dont currently have a a relationship with this table you can create one.  Just remember that the table with the users choices needs to be the child in the relationship.