average time

[bhavvibudagam]

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

[Gysbert_Wassenaar]

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?

[bhavvibudagam]

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);

[jonathandienst]

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.