Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to calc MTTR(mean time to resolve)?

Hi,

I have a around 1lakh of data. I need to calculate the mean time to resolve for the overall tickets that are present in the dump.

for example:

   

NumberOpenedClosed
10223/18/2015 16:043/19/2015 23:55
10233/19/2015 7:253/19/2015 12:33
10243/16/2015 15:313/18/2015 9:20
10253/23/2015 8:153/24/2015 9:40
10263/23/2015 8:203/24/2015 9:40
10273/23/2015 8:333/24/2015 9:37
10283/23/2015 8:393/24/2015 9:40
10293/23/2015 8:423/24/2015 9:36
10303/23/2015 8:233/24/2015 9:40
10313/23/2015 8:243/24/2015 9:40
10323/23/2015 8:413/24/2015 9:34
10333/23/2015 8:443/24/2015 9:37
10343/16/2015 15:343/17/2015 12:28

thanks in advance

6 Replies
Master III
Master III

You mean something like this?

sum(Closed - Opened)/count(Number)

May you live in interesting times!
Not applicable

yes

Not applicable

I want it in hours

Champion III
Champion III

sum(Closed - Opened)/count(TOTAL Number)

Master III
Master III

Multiply by 24 .

May you live in interesting times!
Contributor
Contributor

it is working for me, thanks all