topic Re: average time in QlikView

average time

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi can any one please help me to do.

I have attached the raw data sample in the above and one generated report.

I have taken CALLTYPE as dimension and in expresssions

for number of units i have taken sum(UNITS_COUNT) and

for avg number of units i have taken sum(UNITS_COUNT)/SUM(TOTAL UNITS_COUNT)

Now i need to calculate the " Average time on call per unit" .

I have TIME_ON_CALL field with CLEAR_SECONDS - ARRIVE_SECONDS AND UNID AND UNITS_COUNT FIELD.

PLEASE HELP ME TO CALCULATE THE Average time on call per unit.

Thanks

Re: average time

Gysbert_Wassenaar — Fri, 30 Sep 2016 11:11:44 GMT

What's a unit? Is it a unitid or a UNIT_COUNT value of 1?

What is TIME_ON_CALL? Is it the total time on call for all of the units of a value of UNIT_COUNT or should TIME_ON_CALL be divided by UNIT_COUNT?

Re: average time

bhavvibudagam — Fri, 30 Sep 2016 11:17:37 GMT

Hi,

please find the below script

UNIT_COUNT Field indicated the numbers of unitids in the corresponding call types at different time slots.

PDARCH_TIME_ON_CALL:

LOAD EID,

UNID,

ARRIVE_SECONDS,

CLEAR_SECONDS,

CLEAR_SECONDS - ARRIVE_SECONDS AS TIME_ON_CALL,

IF(ARRIVE_SECONDS = 0 OR CLEAR_SECONDS=0,'EXCLUDE1','INCLUDE1') AS TIME_ON_CALL_FLAG

FROM

[....\PDARCH_TIME_ON_CALL_VW.qvd]

(qvd);

left join

LOAD UNITS_COUNT,

EID

FROM

[....\PDARCH_UNITS_ARRIVED_COUNT.qvd]

(qvd);

Re: average time

jonathandienst — Fri, 30 Sep 2016 11:21:33 GMT

I suggest that at very least, you attach some data in a readable form (not a picture). Better still, load some sample data into a small qvw file and upload that file, together with the results that you would like to achieve.