In this video, the speaker explores the Resolution Time Report and explains its usefulness in identifying trends and incidences that can help ensure faster issue resolution. The report shows the average length of time taken to resolve a set of issues for a project filter. The speaker discusses the importance of applying the correct filter, selecting the scale and time duration, and explains how the average resolution time is calculated. The speaker also cautions that the average could be misleading due to long pending issues or the number of issues resolved on a particular day and recommends presenting the number of issues used for calculating the average to make the information more sensible for viewers, like management. The video concludes with the speaker explaining how to calculate the average resolution time using Excel and emphasizing the importance of not getting carried away by the length of the graph, but instead considering the number of issues resolved on a particular day to make a sensible average.
Ещё видео!