How can I build a report displaying the average time incidents have been put on hold the past year

[Ford5]

Hello all, I am trying to create a report displaying the average time incidents have been on hold, over the past year, and their associated reasons.  Any and all help will be greatly appreciated.  

[Chimenem · Accepted solution]

Hello Ford5,

You can try below and confirm if it solved the problem:

[Chimenem · Accepted solution]

Hello Ford5,

You can try below and confirm if it solved the problem:

[Ford5]

Chimenem thank you that worked, but I was just asked for additional information.  How do I also show the associated reasons for being on hold?

(Ex) I would like to see the average time for tickets to be on hold over the past year with their associated reasons.

[jMarshal · Accepted solution]

This probably already has that info baked-in as a drill-down list. If you allow drill-down, clicking on the value (10 hours in the example above) should take you to a list of all the records that were used in the calculation. Just display the list with "on hold reason" as the group-by column.