Hello,
I have a problem I wasn't able to solve myself. I hope someone of you guys can help me out.
I want to calculate the average temperature by useing weather data I get from another source.
The data looks like the following:
| location | collectionDate | considerationDate | temperature |
|---|
| London | 03.05.2016 | 02.05.2016 | 10 |
| London | 03.05.2016 | 03.05.2016 | 8 |
| London | 03.05.2016 | 04.05.2016 | 7 |
| London | 02.05.2016 | 01.05.2016 | 11 |
| London | 02.05.2016 | 02.05.2016 | 9 |
| London | 02.05.2016 | 03.05.2016 | 16 |
| New York | 03.05.2016 | 02.05.2016 | 19 |
| New York | 03.05.2016 | 03.05.2016 | 15 |
| New York | 03.05.2016 | 04.05.2016 | 13 |
| New York | 02.05.2016 | 02.05.2016 | 17 |
| New York | 02.05.2016 | 03.05.2016 | 18 |
| New York | 02.05.2016 | 04.05.2016 | 22 |
The data is collected on a certain date as a forecast (and in addition the real temperature of yesterday) for a few days. And on the next day the data gets collected again, but now for one day later.
If I want to get the average forecast temperature for the day in consideration (i.e. 02.05.2016) I have to get avg of the two orange values. The result would be 9.5.
The resulting diagram should look something like that:
| location | DayOfInterest | avgTemperature |
|---|
| London | 02.05.2016 | 9.5 |
| London | 03.05.2016 | 12 |
| New York | 02.05.2016 | 18 |
| New York | 03.05.2016 | 16.5 |
I already made a master calendar for the "DayOfInterest", but it didn't helped.
I hope someone can help me. Thanks in advance!
Kind regards
Markus
