Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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);
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.