Skip to main content
Question

Can you use the Gauge report to display the percentage instead of a summed number?

  • January 3, 2017
  • 0 replies
  • 103 views
I would like a way to display the percentage instead of the summed number. The report knows the percentage since it's used for the color range. Is there any way to simply display that percentage number instead of the summed number?
This topic has been closed for replies.

  • MCFNeil
  • Registered
  • March 17, 2017
It would be all too easy if QuickBase gave that option because it makes too much sense.

Here is a work-around until that happens.

You will need to summarize the data to a parent table.  Already exist, but you may need to create a "Months" or "Quarter" table, depending on the time frame you are looking for in the gauge chart.

You'll then want to create a formula numeric field that displays as a percent.  

Have this field add your total that is summarized then be divided by your "goal" (i.e. 100%).

Then you will have a total.

When you create your gauge report, make the value be based on that new field, and your goal will be "1".

Now you have your % gauge report.
Terms & ConditionsAccessibility statement