Set analysis for time

[prma7799]

Hi All,

I have two fields status = ACD and SLA =2:55:00 AM like this.

I want total number of call logs where status is ACD and SLA is less than 30.

for that i wrote expression like Count({<sStatus={'ACD'} , SLA ={}[Call Log ID]).

So how to fine SLA is less than 30.

Thanks

PM

[prma7799]

Yes I tried but values is getting 0.

[sunny_talwar]

Did this work? If not what is the current format of your field SLA? is it m:ss

[jagan]

Hi,

It is working for me, can you attach a sample file?

Regards,

Jagan.

[prma7799]

Hi Jagan,

PFA for the same.

Thanks

PM