Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 julruiz123
		
			julruiz123
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
I have the next timeline table
Timeline: 
LOAD * INLINE [ Hour, Hour_Min, Hour_Range 
0, 00:00, 00:00-01:00 
1, 01:00, 01:00-02:00 
2, 02:00, 02:00-03:00 
3, 03:00, 03:00-04:00 
4, 04:00, 04:00-05:00 
5, 05:00, 05:00-06:00 
6, 06:00, 06:00-07:00 
7, 07:00, 07:00-08:00 
8, 08:00, 08:00-09:00 
9, 09:00, 09:00-10:00 
10, 10:00, 10:00-11:00 
11, 11:00, 11:00-12:00
12, 12:00, 12:00-13:00
13, 13:00, 13:00-14:00
14, 14:00, 14:00-15:00 
15, 15:00, 15:00-16:00 
16, 16:00, 16:00-17:00 
17, 17:00, 17:00-18:00 
18, 18:00, 18:00-19:00 
19, 19:00, 19:00-20:00
20, 20:00,20:00-21:00 
21, 21:00, 21:00-22:00 
22, 22:00, 22:00-23:00 
23, 23:00, 23:00-00:00 ];
And this other table
Fecha registro - Hora registro
2011-01-01        11
2011-01-01        08
2011-01-02        23
2011-01-03        16
I need a histogram with the number of records of each hour of the timeline.
This is my expression but it doesn't work
Count({$<[Hora registro] = p(Hour)>}[Hora registro])
Any suggestion ?
Thanks
 
					
				
		
 julruiz123
		
			julruiz123
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
This is the solution if someone need it.
Count(if(Hour = [Hora registro],[Hora registro]))
 
					
				
		
 julruiz123
		
			julruiz123
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
This is the solution if someone need it.
Count(if(Hour = [Hora registro],[Hora registro]))
