I have a data table with records of power readings stored Date wise. Now I have to create a report that does the calculations from the data as below.
1. Average of readings of last week's data.(last 1-7 days)
2. Average of readings of previous week's data.(last 8 - 14 days)
3. Average of reading of prev. month's data. (last 15 - 45 days).
Now my question is how to extract the data from table date wise as required.
Also if there is any way I can store only 45 data records starting from yesterday till last 45th day then pls help me how to achieve this ??