Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a data like shown below, it contains all dates from when application started to till date and its respective datas.
Now i need to put a line graph with Dimension - Date(Monday to Sunday), UserType . Measure - Pageviews. But data display should be weekly from Monday to Sunday.
i.e for example : 05/12/2016 - 11/12/2016 ,for New visitor it should display sum of Pageviews and for Returning Visitor it should display sum of Pageviews.
Date | UserType | Pageviews |
16-12-2015 | New Visitor | 77 |
16-12-2015 | Returning Visitor | 36 |
17-12-2015 | New Visitor | 72 |
17-12-2015 | Returning Visitor | 16 |
18-12-2015 | New Visitor | 82 |
18-12-2015 | Returning Visitor | 11 |
19-12-2015 | New Visitor | 113 |
19-12-2015 | Returning Visitor | 39 |
20-12-2015 | New Visitor | 19 |
20-12-2015 | Returning Visitor | 16 |
21-12-2015 | New Visitor | 41 |
21-12-2015 | Returning Visitor | 27 |
22-12-2015 | New Visitor | 60 |
Any kind of help is appreciated on this
Regards,
Supriya
Create a week field in the script and use that as dimension:
LOAD
Date,
Dual(Date(WeekStart(Date),'DD/MM/YYYY') & '-'
& Date(WeekEnd(Date),'DD/MM/YYYY'), WeekStart(Date)) as Week,
UserType,
Pageviews
FROM
....source data...
;
Create a week field in the script and use that as dimension:
LOAD
Date,
Dual(Date(WeekStart(Date),'DD/MM/YYYY') & '-'
& Date(WeekEnd(Date),'DD/MM/YYYY'), WeekStart(Date)) as Week,
UserType,
Pageviews
FROM
....source data...
;