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

Respondida

1 Comentários

  • Comentário oficial
    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

Por favor, entrar para comentar.

Powered by Zendesk