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!
The reason filtering on 10 does not work is that the report filters individual Metric Result records. So an agent who has an 8, 9 and 10 will still appear because one of their records matches 10.
I would solve this with a Database View plus a Report Source. The Database View can expose the relationship from Metric Result through Instance and Task to Assigned to. Then use that view as the data source for the Platform Analytics pivot report.
In the Report Source, add a predefined condition that excludes any agent who has a result other than 10 for the selected week. That way the pivot only receives data for agents whose results are all 10, instead of just showing agents who have at least one 10.
Since I don't have the exact table/field, i did include an example below. You should create the report source from the database view, and add it in the predefined conditions.
1.
2.
