I just gave an example of the data. The data will be spread across multiple years, and possibly every user will have usage data very random throughout the day/week/month/year. In the end, I want daily usage,weekly,monthly and yearly usage for all the users combined in DB i.e. the end result would be:
For the sample data that I posted:
daily
=====
Date Avg Usage
10/01 5/# No. of users
10/03 2/# No. of users
10/04 21/# No. of users
Weekly (if my week starts on sun)
=====
Week # Avg Usage
4028/# No. of users
4148/# No. of users
and so on..