Recent searches
No recent searches
Explore - How to exclude lunch break time from reporting i.e. 12:30pm-1:pm?
Answered
Posted Apr 07, 2021
Hi!
I hope someone can help me.
I want to build a custom metric / filter in Explore, to exclude in Talk Dataset all calls between 12:30pm to 1pm.
I can use Leg -Hour but when select 12 it will exclude 12pm to 1pm.
Can someone make me a formular how to get this sorted?
I tried this one:
IF DATE_FORMAT([Leg - Timestamp],"HH:MM") >= "12:30"
AND DATE_FORMAT([Leg - Timestamp],"HH:MM") < "13:00"
THEN "Exclude"
ELSE "Include"
ENDIF
It´s partially working if time is 12:00 to 13:00, but if I use "12:30" the minute value is ignore / not working.
Thanks so much.
Tobias
0
1
1 comment
Official
Ram
Hello Tobias,
I have not tried this, but you can test this formula:
Hope this helps,
Ram
0