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


1 Commentaires

  • Commentaire officiel
    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"
    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]

    Hope this helps,

Vous devez vous connecter pour laisser un commentaire.

Réalisé par Zendesk