Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 sona_sa
		
			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
		
			Ksrinivasan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		hi,
try this
Count({<ticket_time= {"=$(Max(ticket_time))<=$(Max(ticket_time)-02:00:00))"}>}ticket)
ksrinivasan
 
					
				
		
 sona_sa
		
			sona_sa
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thanks Ksrinivasan, Let me check.
