Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

Report on Agents who ONLY got 10s in surveys for the week

Mark Becker
Tera Expert

I'm running a pivot table report to show actual results across the top and agent names down the left. I want to filter this report to only show the agents who ONLY got 10s. If I filter to 10 then I get the agents who got SOME 10s if that makes sense. The result of the filter should be the 7 agents below who ONLY got 10s for the week. I've tried Related List but we don't have a connection to Metric Result -> Instance -> Task -> Assigned to. I've tried to filter on Avg is 10 but can't find that or Minimum is 10 but can't find that. Thanks!

 

MarkBecker_0-1788440809251.png

 

0 REPLIES 0