Explore - How to exclude lunch break time from reporting i.e. 12:30pm-1:pm?
回答済み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
-
正式なコメント
Hello Tobias,
I have not tried this, but you can test this formula:
IF [Leg - Hour]=12 AND [Leg - Minute]>29
THEN "12:30-1 PM"
ELSE "Not"
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]
ENDIFHope this helps,
Ram
サインインしてコメントを残してください。
1 コメント