Skip to main content
Question

Create a Gauge Report that displays %


I am trying to set up a gauge report that displays % completion, to display on new dashboard as a single %.

Numerical percent formula field:
[# of Content Reviews Completed]/[# of Active Content]/100

Gauge Report set up:
Gauge measures:  Numerical percent formula field (above), summarized by (summed)
Start at 0
Goal = 1
Filter:  Content Status = Active

Gauge Results: The total # completed, not the % completed.



------------------------------
Colleen Burch
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

Try using an Average instead of a Sum and see if the math is right for your use case. 



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------