AnsweredAssumed Answered

Line Chart- Sum by week/ month from daily table

Question asked by ZaraRose on Apr 28, 2015
Latest reply on Apr 29, 2015 by ZaraRose

Title

Line Chart- Sum by week/ month from daily table

Post

Hi all

 

My database has a URL table the has 3 fields url , daily unique visitors, date.

I'm trying to have a history line charts for the data that display daily/weekly /monthly unique visitors

I'm having problem with calculating the weekly ( the last 26 weeks) visitors for each url

and the Monthly  visitors ( Last 12 Months) 

does anyone have any suggestion on how to accomplish this ? 

Outcomes