CMS CALL PROFILE MULTI SKILL MULTI DATE

[GarethRoynon]

Hi,

Ive created a Call Profile Report from scratch which looks at multi dates from the daily table and multi skills. It all works fine and Im trying to get the totals to work. Ive created a new query for the totals and wanted to put an extra box with the totals at the top.
The ACD calls and ABA calls all total up fine but Im having a problem with the PERIOD1-9 totals. As its multi days and multi skills I cant figure the formula to total the figures under the period1 etc. I tried sum(period1) but of course this adds the secs up and comes up with 1:00 when the period is 0-5 and there were 12 lines to add up.

I hope this is making sense!

Ultimately, how can I add up the individual calls from multi days and skills under the 0-5 sec period.

So itd look like this>
Total Calls Handled 0-5 Secs From all skills and days input =

Thanks...

 

[TykeUK]

This sounds like a similar issue I had with starttime + intrvl in a multiskill interval report. As soon as a sum formula was used on this calcluation "sum(hsplit.STARTIME) + sum(hsplit.INTRVL)" the return value summed the actual start times and Interval times!

I got around this by using the formula "AVG(hsplit.STARTTIME) + AVG(hsplit.INTRVL)" This returned the correct interval time.

Maybe you can use "Avg(Period1)

 

[GarethRoynon]

Hey thanks for the response. ive just figured it though. It wasnt PERIOD1 it was ACDCALLS1 so when I put in Sum(ACDCALLS1) it brings it up. PERIOD1 is just the time definition so its all cool now.

Oh i love CMS reports!! mmmmmm