Explore - How to exclude lunch break time from reporting i.e. 12:30pm-1:pm?

답변함

2021년 4월 07일에 게시됨

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

댓글 1개

날짜

공식

2021년 4월 20일

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

댓글을 남기려면 로그인하세요.