Duplicate Counts in Cross Tab Report
I am trying to create a report that shows the total number of incidents, along with total number that have met a resolution/response service level agreement, broken out by incident priority.
To achieve this, I have a total number of incident column, as well as 2 calculated fields to calculate the number of incidents that met their resolution/response targets. The calculated fields look as follows:
CASE WHEN Goal Category = 'Incident Response Time' AND Measurement Status = 'Met' THEN COUNTDISTINCT ( Application Instance ID ) END
CASE WHEN Goal Category = 'Incident Resolution Time' AND Measurement Status = 'Met' THEN COUNTDISTINCT ( Application Instance ID ) END
The issue I am facing is when one of these fields is included in the report, my total number of incidents double and I'm not sure why. Does anyone have any idea as to why this would happen? If it helps, most of my fields are from one table, while the resolution/response fields listed in the above calculations are from a different table. I have also attached a screenshot of my report with the doubled total number of incidents.