1 Reply Latest reply: Nov 21, 2011 2:57 PM by Felipe Ruiz RSS

    Count records in a timeline table

    Felipe Ruiz

      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