Is this what you are looking for? I used a table calc function to lookup temperatures predicted 1 hour earlier. See attached workbook.
Hope this helps.
thank you so much. This is a great start to have both values available. Is there a way to show them as separate points / lines though to make the difference visible. In the end I would like to have a line chart that shows the current vs the 1-12 hour forecasts over time. So 13 lines.
thanks so much. Putting the two lines in one diagram was easy Wonderful.
Have a nice day, Sandra
You are welcome Sandra. Good you figured it out.
I have two question regarding this table calculation
LOOKUP(MIN([Forecast1 Temperature]), -1)
I would like to aggregate these measures across locations to show the average current temperature vs the average 1-12 hour forecast? As I understand the calculation, lookup returns the value of a target row, but can I perform calculations "on Top", such as aggregation.
What is the reason for using MIN?
Thanks a lot and kind regards,
All fields must be aggregates when using table calculations. Hence, I used MIN() to aggregate Forecast1 Temperature. You can also use ATTR(), MAX(), SUM() or AVG() depending on the data type. It is a row level calculation, so wouldn't matter the one you choose as long as the data type is compatible.
All table calculations are already pre-aggregated and cannot be further aggregated. It depends on what you want to do. You can aggregate the forecasts before applying the lookup function.