Combining the results of 2 reports into 1 calculation

Joe Taylor
Giga Guru

I am trying to create a very specific report from the Incident table.

 

For a particular time period (e.g. last week, last month, last year, etc.) I want to divide the total number of incidents that were reopened by the total number of tickets that were resolved for that period.

 

For example:

Last week, there were 8 Incidents that were resolved, then reopened at least once before being resolved again.

There were 100 tickets in total that were resolved.

I want to display a 8.00% in a report somehow.

 

What's the best way to do this?

1 REPLY 1

AndersBGS
Tera Patron
Tera Patron

Hi @Joe Taylor ,

 

the best solution will be to utilize performance analytics. Here you can create two indicators and a formula indicator to do the calculation.

 

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

 

Best regards

Anders

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/