Forum Discussion

ColleenBurch's avatar
ColleenBurch
Qrew Trainee
2 years ago

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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    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
    ------------------------------
    • ColleenBurch's avatar
      ColleenBurch
      Qrew Trainee
      2 years ago

      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        2 years ago

        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
        ------------------------------