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

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"
ENDIF
You 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]
ENDIF

Hope this helps,
Ram

0


Please sign in to leave a comment.

Didn't find what you're looking for?

New post