Discussions

Expand all | Collapse all

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

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

    Posted 01-03-2017 14:58
    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?


  • 2.  RE: Can you use the Gauge report to display the percentage instead of a summed number?

    Posted 03-17-2017 05:10
    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.