Hello,
My database schema like this:
schedule_date schedule_amount
2014-09-19 / 100
2014-09-19 / 150
2014-09-26 / 50
2014-09-26 / 50
2014-10-03 / 50
... ...
2015-09-18 / 75
2015-09-25 / 30
2015-10-02 / 40
My aim is, to see "Week X" revenue on 2014 and 2015. (In this example 2014 & 2015 is the range. Next year, it'll show 2015 and 2016).
To better understanding, see here: [login to view URL]
- Payment dates are always on Friday.
- Range should be April to March instead of January to December (because of our financial year).
- If you use [login to view URL] even better: [login to view URL] (not required as long as you send me graph like attachment)
Thank you, happy bidding.