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"
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.