Sum Multiple data values into single Dimension

[berryandcherry6]

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

DateCreated	Sent
01-02-2017	2
01-02-2017	2
01-02-2017	3
02-02-2017	2
03-02-2017	7
04-02-2017	8
04-02-2017	9
04-02-2017	12
12-02-2017	56
01-02-2017	23
20-02-2017	56
19-02-2017	3
13-02-2017	2
17-02-2017	8
18-02-2017	0
19-02-2017	5

But i need to script to produce like this  

DateCreated	Sent
01-02-2017	30
02-02-2017	2
03-02-2017	7
04-02-2017	29
12-02-2017	56
13-02-2017	2
17-02-2017	8
18-02-2017	0
19-02-2017	8
20-02-2017	56

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;

[Anil_Babu_Samineni]

Is this?

[berryandcherry6]

Hi Anil,

Thanks for reply!. Yes, it is as in shown graph. I am using Qliksense. can you post script or txt file in here.

[Anil_Babu_Samineni]

Even Qliksense it working

I am not sure, Which script you are expecting from my end ?

[berryandcherry6]

Can you please look into this attached sample. Here i am combining two different tables date to display data for last 6 Months. But it shows me repeated date.

[Anil_Babu_Samineni]

May be use Join

Source:

LOAD UserTypeTotalView,

Date(Date#(DateTotalView,'YYYYMMDD'),'MM-DD-YYYY') as  DateLink,

    HitsTotalView,

     Year(DateTotalView) AS TrafficYear,

    num(Month(DateTotalView), '00') As TrafficMonth_Num ;

SQL SELECT UserTypeTotalView,

    DateTotalView,

    HitsTotalView

FROM TotalViewTrafficTable;

Join(Source)

LOAD delivered,

campaign_metrics_id ,

sent,

bounced,

opened,

email_type_id as email_metric_type_id,

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

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

SQL SELECT delivered,

sent,

campaign_metrics_id,

bounced,

opened,

email_type_id,

date_created

FROM EMAILMETRICS;

[berryandcherry6]

No this is showing multiple data for same date