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
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)
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)