6 Replies Latest reply: Mar 3, 2017 3:53 AM by Supriya R RSS

    Sum Multiple data values into single Dimension

    Supriya R

      Hi,

       

      i have a data where i have multiple data values for a single Date, If i use this data i get multiple values for same data.

      But i need it to show Sum of data values to that particular Date.

      My data is as below

        

      DateCreatedSent
      01-02-20172
      01-02-20172
      01-02-20173
      02-02-20172
      03-02-20177
      04-02-20178
      04-02-20179
      04-02-201712
      12-02-201756
      01-02-201723
      20-02-201756
      19-02-20173
      13-02-20172
      17-02-20178
      18-02-20170
      19-02-2017

      5

       

      But i need to script to produce like this  

      DateCreated      Sent
      01-02-201730
      02-02-20172
      03-02-20177
      04-02-201729
      12-02-201756
      13-02-20172
      17-02-20178
      18-02-20170
      19-02-20178
      20-02-201756

      I am thinking this way, to display datas in LIne Chart. So that it shows one value to respective date

      My Load Script

       

      LOAD Sent,

      date(floor(date_created),'MM-DD-YYYY') as DateCreated;

      SQL SELECT Sent,

      date_created

      FROM EMAILMETRICS;