I need a filter for a scoreboard chart (count records less than 90% Compliance rate). The compliance rate I’m calculating = SUM(Hours)/SUM(Capacity). I’m currently calculating this on the chart level.
But filters won’t let you use chart level calculated fields. So I made the same calculation at the report level.
Problem is that the report level field aggregates over again once I use it in a chart. So if the compliance rate before was 71%, now it’s like 2,676%, something like that, just made up the second number but it’s really big. I get close to the actual when I average it but it’s not exact and unreliable. I’ve double checked and the first calculation is the correct percentage.
How can I make a report level field that will aggregate correctly? How can I get it to that correct 71%?