최근 검색

최근 검색 없음

Count incoming ticket by specific time

답변함
image avatar

CS Agent

2021년 6월 22일에 게시됨

I would like to count incoming ticket by specific time with formula as below:

- #Incoming ticket daily = total ticket of previous date from 17:00-23:59 + total ticket of current date from 00:00 to 16:59

Is there any way to create the report as requirement ?

0

1

댓글 1개

날짜
    image avatar

    John Espina

    Zendesk Customer Care

    Hi Edwin,

    You can try this formula:

    IF (([Ticket created - Date]=DATE_ADD(TODAY(),"day",-1)) AND ([Ticket created - Hour]>16))or (([Ticket created - Date]=TODAY()) AND ([Ticket created - Hour]<17))THEN[Ticket ID] ENDIFIt will give you this: https://www.evernote.com/l/AkCqHHz6LFVGf6vhd_qVcQU_clOmT5K0xTI

     

    0

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

    원하는 정보를 못 찾으셨나요?

    새 게시물