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]...
Forum Discussion
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
------------------------------
Switched from summed to average, the gauge display appears to be about what it should be (24%), but the % displays at 0%. Ideas?
------------------------------
Colleen Burch
------------------------------
Well, you could set the goal at 100 and alter a formula to multiply by 100.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Working great now...thank you!
------------------------------
Colleen Burch
------------------------------
