my requirement is to display volume for rolling 28 days in a line chart where x-axis is days and y-axis is volume
consider table :
| date | date-28 | volume expression to be in chart |
|---|
13/05/2014 | 15/04/2014 | sum({<date = {>=15/04/2014,<=13/05/2014}>}quantity) |
| 12/05/2014 | 14/04/2014 | sum({<date = {>=14/04/2014,<=12/05/2014}>}quantity) |
| .. | | |
| .. | | |
| 01/05/2014 | 03/04/2014 | sum({<date = {>=03/04/2014,<=01/05/2014}>}quantity) |
This what i required
Table represent seems easy but dynamically should display volume for last 14days
