1 of 1 people found this helpful
Would you please explain bit more on these formulas.
Assigned Incidents = Number of incidents submitted based off reported date. So In July 2017, 640 incidents were submitted.
Resolved Incidents = Number of incidents resolved for that month so in July 2017, 628 incidents were resolved.
Are the Resolved incidents based on the Last Resolved Date? (could be some of them from carry overs?)
Carryover Incidents = Number of incidents that were still open at the end of the month that were carried over to the next month so in July 2017 63 incidents were still open for that support group.
You should be able to do it easily, you will need two org reference code one for reported date and one for last resolved date and few calculated fields.