Forum Discussion

TeresaSteeg1's avatar
TeresaSteeg1
Qrew Trainee
2 years ago

Gauge Report - Wrong Percentage

Hi! I'm creating a gauge report that shows the percentage of POs Invoiced/Current Project Budget (aka Percent Consumed).  This report is going on a dashboard that has a dynamic filter for Project Pr...
reports
TeresaSteeg1's avatar
TeresaSteeg1
Qrew Trainee
2 years ago

Yes, I have tried that too.  I changed the "What does the gauge measure?" field from the formula to [... Percent consumed - ALL] .  The percentage is correct at 13.4%, but then the dynamic filter does not work.  It just continues to show 13.4% no matter what priority you choose.

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    I'm guessing you're set up as you have maybe a single universal reporting record with Record ID number 1 where you were doing the summary totals.

    But your gauge chart is operating on the detail records.  The detail records probably have a field called  [Percent Consumed].

    Try using that field [Percent Consumed] in the Summarize What setting.