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

  • 0
  • 1
  • Question
  • Updated 2 years ago
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?
Photo of Alan

Alan

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
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.