Create a report on Incident resolved at first time

[Adarsh T]

Hi

I have a requirement to create a report for the incident resolved at first attempt.

The conditions is as follows: It should be pie chart report showing a number and percentage of incidents in state "Closed" where there were no state changes registered after state changed to "Closed" against a total number of incidents in state "Closed" where state changed after the Incident state was changed "Closed".

What filter condition I should apply for this?

[tanvi deshpande]

Hi,

Can the user reopen the incident after its resolved and will that impact the reopen count ?

if the answer is no and the reopen count updates only on reopening of closed incidents than you can create the pie chart using performance analytics.

Numerator = count of all closed incidents 

scripted breakdown which will create a new mappings of 

x = closed incidents with reopen count as 0

y= closed incidents with reopen count as > 0

creating scripted breakdown mapping for reopen count field. and applying to our numerator

and then creating pie chart widget with this scripted breakdown selected as breakdown. N in display you can select if you want to see it as percentage.