Combining the results of 2 reports into 1 calculation

[Joe Taylor]

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?

[AndersBGS]

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