2 Replies Latest reply: Sep 13, 2012 3:39 AM by Srikar Chaduvu RSS

    Aggregate the data based on time stamp

      Hi

       

      I want the data to be aggregated based on the timestamp.

       

      For example:

       

      During

       

      12/08/2012 08:00:00   -----------Product1------------12 sales occured.

      12/08/2012 08:00:00   -----------Product2------------3sales occured.

      12/08/2012 09:00:00------------Product1------------2sales occured.

      12/08/2012 09:00:00------------Product2------------3sales occured.

       

      This means between 7 and 8 12 sales occured and between 8 and 9 5 sales occured.

       

      But when I create a straight table, I get the data this way.

       

      12/08/2012 08:00:00   ---------Product1--------------14 sales occured.

      12/08/2012 08:00:00   -----------Product2------------6 sales occured.

      12/08/2012 09:00:00-----------Product1----------------14 sales occured.

      12/08/2012 09:00:00-----------Product2----------------6 sales occured.

       

      The data is getting aggregating based on products . Can any one help me with this please?

       

      Regards,

      Jai