Skip to main content
Solved

Average Age of open incidents in freshservice analytic


Forum|alt.badge.img+1

Hi there, 

Can anybody help me here? 

I want to make a matrix in the analytic site that measure the Average age of open incidents in our dept. 

Is this possible? If so, what type of matrix should be used? 

 

I have tried for days now, and nothing will give me the result that I am searching for. Could it be that such a simple and used matrix is not just able in Freshservice yet? 

Best answer by eeha0120

Hi.

Are you looking for something like this?

 

Hope this helps.

 

Regards,

View original
Did this topic help you find an answer to your question?

3 replies

eeha0120
Skilled Expert
Forum|alt.badge.img+12
  • Skilled Expert
  • 746 replies
  • Answer
  • April 2, 2024

Hi.

Are you looking for something like this?

 

Hope this helps.

 

Regards,


Forum|alt.badge.img+1

Hi Elvis, 

 

It could be. 

 

Is that the average time spend on Open tickets that is not yet closed/Resolved, as from it it is created, picked up and are worked on? 


eeha0120
Skilled Expert
Forum|alt.badge.img+12
  • Skilled Expert
  • 746 replies
  • April 3, 2024
Debbie Larsen wrote:

Hi Elvis, 

 

It could be. 

 

Is that the average time spend on Open tickets that is not yet closed/Resolved, as from it it is created, picked up and are worked on? 

Hi.

Yes, it is exactly that.

I have grouped by Status as an example of what you could do, but you could not use the Group By clause (or at least by Status, according to your needs) and you would get the average time spent in tickets while not being resolved.

Check out the Metric filter: Status does not incluide Closed/Resolved, and the metric itself: Overall time spent in Business Hours, using the Average function.

You may add other filters to suit your need.

 

Hope this clarifies further.

 

P.S.: Be aware and don’t fall for Spambot responses. I have already reported it.


Reply