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

답변함

1 댓글

  • 공식 댓글
    Ram Claudio
    Zendesk Customer Advocate

    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

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

Zendesk 제공