Re : Count Tickets in Time Interval

[sona_sa]

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,

AI

[Ksrinivasan]

hi,

try this

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

ksrinivasan

[sona_sa]

Thanks Ksrinivasan, Let me check.