I've a dataset of projects with their caracteristics wich is updated every week and I use it to show the evolution since the beginning of the year. The columns are the same every week but the number of project can change (projects added or deleted) and the values of each field can change too.
To load my data, I concatenate my table every week, and differenciate them with the date and the week number.
The next step is to be able to compare two weeks data and show those which has changed.
First to show in two tables the added projects and deleted projects.
Secondly to show projects with a value that has changed compared to last week. This comparison has to be done on every columns.
I have no idea of how to do that and hope someone will be able to help me.
In the attached file ideas on the possible construction of your application. In the table "Change Volume Project" the data of the project parameter at the beginning of the week and the changes for the previous week are shown. The remaining figures should be clear from the contents of the charts. I hope this helps you something.