Store the history of my usage and then have reports to show 'Weekly usage', 'Monthly usage'

Currently, the project shows only the current records. I want the program to store daily history and then show weekly or monthly reports too.
We will have to use a database to store all the data. Make sure the data is purged after some time so that it does not occupy a lot of space.
