Forum Discussion
TeresaSteeg1
Qrew Trainee
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
3 months agoQrew Legend
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.