topic Re: Re : Count Tickets in Time Interval in App Development

Re : Count Tickets in Time Interval

sona_sa — Mon, 20 Dec 2021 21:05:46 GMT

Hi Team,

I need a logic, Suppose I am loading a table where some ticket is generating every minutes of time interval. Now I have to find out in last 2 hours how many tickets has been generated.

Regards,

Re: Re : Count Tickets in Time Interval

Ksrinivasan — Thu, 28 Jan 2021 18:17:57 GMT

hi,

try this

Count({<ticket_time= {"=$(Max(ticket_time))<=$(Max(ticket_time)-02:00:00))"}>}ticket)

ksrinivasan

Re: Re : Count Tickets in Time Interval

sona_sa — Fri, 29 Jan 2021 06:11:12 GMT

Thanks Ksrinivasan, Let me check.