Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I want to calculate the top 5 agent who has refreshed aux codes within 0-3 seconds ....means i want list of that agent who takes Emergency(Comfort) break for 0-3 seconds...I tried below expression but did not get the expected result
if
(Interval(Time(Sum({<Reason={'COMFORT'}>} EventDuration)),'hh:mm:ss') <=MakeTime(00,00,05),Sum( {<Reason={'COMFORT'}>} EventDuration))
Attached my QVW also here for your reference check in sheet 7.
Regards
Sarfaraz
Hi Sarfaraz,
Does the attached work for you?
Iqbal
Hi Sarfaraz, I dont' understand the requirements, you can add an expression like:
Interval(Time(Sum({<Reason={'COMFORT'}>} EventDuration)),'hh:mm:ss')
There you can check that all the agents have an interval time over 5 secs. so all of them returns FALSE in the 'if' comparison and therefore you get the empty table
Dear Iqbal,
Thanks a lot ...the solution is simple inspite i made it complicated ....Anyway thanks a lot it is working now fine.
Regards
Sarfaraz
Dear Ruben
See the Iqbal post above ....Everything will get clear to you ...Thanks for your reply !!
Sarfaraz