Aggregate responses per incident

Summary

Creating a report to show the aggregate responses per incident (RPI), but getting duplicate values and unable to group results.

Content

Hi all

I'm attempting to create a report which shows the aggregate responses per incident calculation (for an individual agent). I'm able to create it in table view that displays a row for each individual incident - by either grouping results or adding a hidden column to make the count unique - but not a single, aggregated metric.

I believe it's because the report outputs a record for each occurance of an interval type (from the inc_performance table) for each incident.