topic Re: Average waitingtime in QlikView

Average waitingtime

Mon, 27 Aug 2012 16:37:35 GMT

Hi experts,

i have a table with a startdate and a enddate.

In my script i have a field that calculates the difference between those fields.

INTERVAL(ENDDATETIME - STARTDATETIME) as HandlingSpeed

So when i look at my table i have the following date in it:

ID Type StartdateTime EnddateTime HandlingSpeed.

1 A 01-01-2012 14:00:00 01-01-2012 14:00:30 0.30

2 A 01-01-2012 14:00:00 01-01-2012 14:01:30 1.30

3 B 01-01-2012 14:00:00 01-01-2012 14:00:20 0.20

4 C 01-01-2012 14:00:00 01-01-2012 14:01:10 1.10

5 B 01-01-2012 14:00:00 01-01-2012 14:00:40 0.40

Now i want the average handlingspeed per type.

I made the following expression:

=avg(aggr(Sum(HandlingSpeed),Type))

this will not give the right answer, does anyone have a idea what i did wrong? I think the problem is in the time format ?!

Mon, 27 Aug 2012 16:42:47 GMT

Have you tried =avg(sum(interval(HandlingSpeed,'hh:mm')))?

Mon, 27 Aug 2012 16:45:09 GMT

I have tried but i won''t get any result.

When you use that construction you do not have a count per Type also i think?

whiteline — Mon, 27 Aug 2012 16:54:02 GMT

=avg(aggr(Sum(HandlingSpeed),Type)) in your case = ((0.3 + 1.3) +(0.2 + 1.1) + 0.4) / 3

What is the right answer ?

Mon, 27 Aug 2012 16:57:56 GMT

See attached. Hope it helps.

Mon, 27 Aug 2012 16:58:27 GMT

ID Type StartdateTime EnddateTime HandlingSpeed.

1 A 01-01-2012 14:00:00 01-01-2012 14:00:30 0.30

2 A 01-01-2012 14:00:00 01-01-2012 14:01:30 1.30

3 B 01-01-2012 14:00:00 01-01-2012 14:00:20 0.20

4 C 01-01-2012 14:00:00 01-01-2012 14:01:10 1.10

5 B 01-01-2012 14:00:00 01-01-2012 14:00:40 0.40

Average:

A = 0.30 + 1.30 (minutes) = 2 minutes / 2 = 1 minute average

B = 0.20 + 0.40 (minutes) = 1 minutes / 2 = 0.3 minutes average

C = 1.10 minutes / 1 = 1.10 minutes average.