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

Answered

1 Comments

  • Official comment
    Ram Claudio

    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

Please sign in to leave a comment.

Powered by Zendesk