7 Replies Latest reply: Oct 6, 2014 4:41 AM by Shrihari J RSS

    Count by hours??

      Hi All,

       

      I have a requirement where i need to put a chart like Count and Sum by only hour irrespective of date, example below

       

      01/02/2014 00:12:25

      01/02/2014 00:30:29

      02/02/2014 01:40:25

      05/02/2014 01:18:25

      03/02/2014 02:13:25

      09/02/2014 02:16:25

      25/02/2014 02:54:25

       

      so when i take count, the output should be below

       

      hour   count

      00       2

      01       2

      02       3

       

      so please help me achieving this!!