Example: Assistance with Simple Forecast Table(s) #212
Description
I am trying to build/extend from Template : https://dashtweak.com/dashboards/190/view
a new Dashboard which should become THE Weather forecast Table
https://dashtweak.com/dashboards/214/view
But I am struggling : either it is the Query or it is reading the fields and assigning them to the right columns.
The following forecast parameters should be listed in the table. per day in the future
Next 7 days (Daily Forecast)
date,min(temperature),max(temperature),max(windspeed),precipitation,icon,description
Once this can be done per day the following is also required, different table/dashboard
Next 2 days (4 values, 0-6, 6-12, 12-18, 18-24)
date,min(temperature),max(temperature),max(windspeed),precipitation,icon,description
Here a typical Chronograph Query producing a LineGraph
SELECT max("temperature") AS "max_temperature" FROM "forecasts"."autogen"."forecast_corrected" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND "forecast_service"='darksky' AND "installation_id"='1.0' GROUP BY time(1d) FILL(null)