SELECT last("temperature") FROM "autogen"."state" WHERE ("entity_id"::tag='forecast_home') AND $timeFilter GROUP BY time($interval) FILL(none)
Requires the Meteorologisk institutt (Met.no) integration and did not need the ‘include: entities:…’ in my influxdb config. I worked it out by poking around influxdb where I stumbled upon the data. I then used the Query generated in influxdb as a starting point in Grafana. a few syntax changes later (following the grafana query from my sensors) and boom, it worked!
I included it on a graph of data from my temperature sensors
(FYI, the sensors are altogether in a box to check the calibration hence why they are close together)
@sharris - many thanks, this has allowed me to graph a loft installed dht22 temp and humidity sensor with the outside forecast temperature. The correlation between both sensor and forecast values give me confidence that my loft is actually well ventilated.