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..