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

# Average temperature over several days

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

• ###### Re: Average temperature over several days

Isn't this just a table chart with dimensions location and considerationDate and a single expression

=Avg(temperature)

?

• ###### Re: Average temperature over several days

Yes, seems like it. You could limit the dates to max(DayofInterest) to get only results for today or days that have past