Forum Discussion

AlanAlan's avatar
AlanAlan
Qrew Member
8 years ago

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

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?
Formulas and functions
reports and charts

1 Reply

Sort By
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    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.