About Time Related Query

[sarfaraz_sheikh]

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

[#2 · Accepted solution]

Hi Sarfaraz,

Does the attached work for you?

Iqbal

[rubenmarin]

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

[sarfaraz_sheikh]

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

[sarfaraz_sheikh]

Dear Ruben

See the Iqbal post above ....Everything will get clear to you ...Thanks for your reply !!

Sarfaraz