Line Chart- Sum by week/ month from daily table
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 ?