charts with daily & weekly data (Rolling Weekly)

[#1]

Hi, I want a chart with daily and weekly data as shown in attached picture.

Columns

Date --- Jan 1st to date

calls duration

please help me out in this by uploading an sample if possible.

Thanks in Advance

[#2]

You could create a cyclical dimension with 2 fields you create in the load script.

For example if you have StartDate as your daily date. You could:

Load
Date(daystart(StartDate), 'DD-MMM-YY') AS StartDateDayView,
Date(WeekEnd(StartDate), 'DD-MMM-YY') as StartDateWeekView
FROM .......(enter path)
WHERE StartDate > '01-Jan-2010'

[#3]

Something like this: