For simplicity I can accept a query of records saved within an hour.so only 24 slots. I know that I create at least one record for every 10 minutes. I want to create a scale for every hour. If I detect 5 or 6 records created I draw a green cell, in the other hand zero records is bad and I create a red cell. In between I can create a gradient from green to red.
How do I query my db for the 24 slots? Thank you No dia Sábado, 21 de Setembro de 2013, [email protected] escreveu: > example needed .... do you want 6*24=144 different groups each one holding > a "slice" of 10 minutes with the number of records in it, given a day? > > i.e. > 1 --> 00:00 to 00:09 --> 3 records > 2 --> 00:10 to 00:19 --> 4 records > .... > 144 --> 23:50 to 23:59 --> 1 record > > > > On Saturday, September 21, 2013 1:47:53 PM UTC+2, Ramos wrote: >> >> Hello, >> how can i count/group how many records were created in a 10 minutes >> period over a day? >> >> Thank you >> > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:_e({}, 'cvml', > 'web2py%[email protected]');>. > For more options, visit https://groups.google.com/groups/opt_out. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
