2 Replies Latest reply: May 3, 2016 9:50 AM by Puttemans Johan RSS

    Average temperature over several days

    Markus Haindl

      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:

      locationcollectionDateconsiderationDatetemperature
      London03.05.201602.05.201610
      London03.05.201603.05.20168
      London03.05.201604.05.20167
      London02.05.201601.05.201611
      London02.05.201602.05.20169
      London02.05.201603.05.201616
      New York03.05.201602.05.201619
      New York03.05.201603.05.201615
      New York03.05.201604.05.201613
      New York02.05.201602.05.201617
      New York02.05.201603.05.201618
      New York02.05.201604.05.201622

       

      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:

      locationDayOfInterestavgTemperature
      London02.05.20169.5
      London03.05.201612
      New York02.05.201618
      New York03.05.201616.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