Recent searches
No recent searches
Count incoming ticket by specific time
Answered
Posted Jun 22, 2021
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 comment
John Espina
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