Report to calculate total active incidents per day irrespective of created or resolved

[tejenderk]

I want a report which can calculate total active incidents per day irrespective of created or resolved. How can i achieve that?

[AndersBGS · Accepted solution]

Hi @tejenderk ,

Your only option is to go with performance analytics, as the normal report designer won't be able to capture the requested data. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Tsura Andreeva]

If you do not have Performance Analytics you could create metric on the incidents table if you do not have one for status or created and use the data from the incident_metric table

[tejenderk]

Can you please explain this in detail, that would help a lot

[Tsura Andreeva]

I was thinking something like this and group by distinct incident id, and create data set for each month