Hi,
I have a table with a weekly snapshot cummulative value like that:
date value
| 2015-10-01 | 1 |
| 2015-10-08 | 8 |
| 2015-10-15 | 22 |
I'd like to make a query that will return data for every single date value in the interval:
date value rem
| 2015-10-01 | 1 | |
| 2015-10-02 | 2 | interpolated |
| 2015-10-03 | 3 | interpolated |
| 2015-10-04 | 4 | interpolated |
| 2015-10-05 | 5 | interpolated |
| 2015-10-06 | 6 | interpolated |
| 2015-10-07 | 7 | interpolated |
| 2015-10-08 | 8 | |
| 2015-10-09 | 10 | interpolated |
| 2015-10-10 | 12 | interpolated |
| 2015-10-11 | 14 | interpolated |
| 2015-10-12 | 16 | interpolated |
| 2015-10-13 | 18 | interpolated |
| 2015-10-14 | 20 | interpolated |
| 2015-10-15 | 22 | |
I made some search here and on the net but i don't have find an easy way to do this.
Can you give me a hints or piece of code to use?
Thanks
Hugo