Explore - How to exclude lunch break time from reporting i.e. 12:30pm-1:pm?Answered
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.
I have not tried this, but you can test this formula:
IF [Leg - Hour]=12 AND [Leg - Minute]>29
THEN "12:30-1 PM"
ENDIFYou can apply this as filter at the query level, or you can reference this attribute in your custom metric. Example:
IF [name of your attribute]="Not"
THEN [Ticket ID]
Hope this helps,
Please sign in to leave a comment.