Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Is this?
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.
Even Qliksense it working
I am not sure, Which script you are expecting from my end ?
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.
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;
No this is showing multiple data for same date