Dashboard for thermostats

Posted on
Sun Dec 02, 2018 3:09 pm
siclark offline
Posts: 1375
Joined: Jun 13, 2017
Location: UK

Dashboard for thermostats

Written for my 14 Heatmiser thermostats so wanted to use variables to pick and choose which to display, and also enable me to build one and get it to repeat for all chosen thermostats.
Displays temp, setpoint, heatison and preheat. heatison and preheat are 100% for on, 0 for off, and shown below the temperature graphs.

You need to create a variable first called Room which contains static list of your thermostat names. I also have heatmiser controlling towerl rail timers, so have an exclusion for those.

Attached is the variable settings, and example.

Grafana is awesome! Full marks to VTMikeL (and racarter for the Heatmiser plugin)

Code: Select all
{
  "aliasColors": {
    "Heat": "#bf1b00",
    "PreHeat": "#e0752d",
    "Temp": "#bf1b00"
  },
  "bars": false,
  "dashLength": 10,
  "dashes": false,
  "datasource": "Indigo",
  "fill": 1,
  "gridPos": {
    "h": 10,
    "w": 12,
    "x": 0,
    "y": 0
  },
  "id": 2,
  "legend": {
    "avg": false,
    "current": true,
    "max": false,
    "min": false,
    "show": true,
    "total": false,
    "values": true
  },
  "lines": true,
  "linewidth": 1,
  "links": [],
  "nullPointMode": "null",
  "percentage": false,
  "pointradius": 5,
  "points": false,
  "renderer": "flot",
  "repeat": "Room",
  "repeatDirection": "h",
  "seriesOverrides": [
    {
      "alias": "TwinsTRV - Valve",
      "yaxis": 2
    },
    {
      "alias": "TRV Valve",
      "yaxis": 2
    },
    {
      "alias": "PreHeat",
      "yaxis": 2
    },
    {
      "alias": "Heat",
      "yaxis": 2
    }
  ],
  "spaceLength": 10,
  "stack": false,
  "steppedLine": false,
  "targets": [
    {
      "alias": "Stat SP",
      "groupBy": [
        {
          "params": [
            "name"
          ],
          "type": "tag"
        }
      ],
      "hide": false,
      "measurement": "thermostat_changes",
      "orderByTime": "ASC",
      "policy": "default",
      "query": "SELECT \"state.temperatureInput1\" FROM \"thermostat_changes\" WHERE $timeFilter GROUP BY \"name\"\n",
      "rawQuery": false,
      "refId": "A",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "heatSetpoint"
            ],
            "type": "field"
          }
        ]
      ],
      "tags": [
        {
          "key": "name",
          "operator": "=~",
          "value": "/$Room/"
        },
        {
          "condition": "AND",
          "key": "name",
          "operator": "!~",
          "value": "/Rail/"
        }
      ]
    },
    {
      "alias": "Temp",
      "groupBy": [
        {
          "params": [
            "name"
          ],
          "type": "tag"
        }
      ],
      "measurement": "thermostat_changes",
      "orderByTime": "ASC",
      "policy": "default",
      "refId": "D",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "state.temperatureInput1"
            ],
            "type": "field"
          }
        ]
      ],
      "tags": [
        {
          "key": "name",
          "operator": "=~",
          "value": "/$Room/"
        },
        {
          "condition": "AND",
          "key": "name",
          "operator": "!~",
          "value": "/Rail/"
        }
      ]
    },
    {
      "alias": "PreHeat",
      "groupBy": [
        {
          "params": [
            "name"
          ],
          "type": "tag"
        }
      ],
      "measurement": "thermostat_changes",
      "orderByTime": "ASC",
      "policy": "default",
      "refId": "B",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "state.preHeat.num"
            ],
            "type": "field"
          }
        ]
      ],
      "tags": [
        {
          "key": "name",
          "operator": "=~",
          "value": "/$Room/"
        },
        {
          "condition": "AND",
          "key": "name",
          "operator": "!~",
          "value": "/Rail/"
        }
      ]
    },
    {
      "alias": "Heat",
      "groupBy": [
        {
          "params": [
            "name"
          ],
          "type": "tag"
        }
      ],
      "measurement": "thermostat_changes",
      "orderByTime": "ASC",
      "policy": "default",
      "refId": "C",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "state.heatIsOn.num"
            ],
            "type": "field"
          }
        ]
      ],
      "tags": [
        {
          "key": "name",
          "operator": "=~",
          "value": "/$Room/"
        },
        {
          "condition": "AND",
          "key": "name",
          "operator": "!~",
          "value": "/Rail/"
        }
      ]
    }
  ],
  "thresholds": [],
  "timeFrom": null,
  "timeShift": null,
  "title": "$Room Heating",
  "tooltip": {
    "shared": true,
    "sort": 0,
    "value_type": "individual"
  },
  "type": "graph",
  "xaxis": {
    "buckets": null,
    "mode": "time",
    "name": null,
    "show": true,
    "values": []
  },
  "yaxes": [
    {
      "format": "celsius",
      "label": "Temp",
      "logBase": 1,
      "max": null,
      "min": "-10",
      "show": true
    },
    {
      "format": "percentunit",
      "label": "Heat On",
      "logBase": 1,
      "max": "4",
      "min": null,
      "show": true
    }
  ],
  "yaxis": {
    "align": false,
    "alignLevel": null
  },
  "minSpan": 12,
  "scopedVars": {
    "Room": {
      "text": "Living Room",
      "value": "Living Room",
      "selected": false
    }
  }
}
Attachments
Screenshot 2018-12-02 at 21.08.02.png
Screenshot 2018-12-02 at 21.08.02.png (424.58 KiB) Viewed 498 times
Screenshot 2018-12-02 at 21.05.33.png
Screenshot 2018-12-02 at 21.05.33.png (174.78 KiB) Viewed 498 times

Posted on
Sun Dec 02, 2018 3:15 pm
siclark offline
Posts: 1375
Joined: Jun 13, 2017
Location: UK

Re: Dashboard for thermostats

And as previous post, but for the coming TRV plugin from autolog.

Also needs same variable setup, this time called TRV. Shows more detail than Heatmiser ones, setpoint from TRV and Stat device, temp from TRV and Remote sensor (where setup) and valve open %.

Naming convention is
Bedroom thermostat
Bedroom TRV
Bedroom TRV Valve

Code: Select all
{
  "aliasColors": {
    "Landing Stat SP": "#70dbed",
    "Landing Valve%": "#f2c96d",
    "Stat SP": "#70dbed",
    "TRV SP": "#629e51",
    "TRV Valve": "#f2c96d",
    "Temp Remote": "#bf1b00",
    "Temp TRV": "#f9934e"
  },
  "bars": false,
  "dashLength": 10,
  "dashes": false,
  "datasource": "Indigo",
  "fill": 1,
  "gridPos": {
    "h": 9,
    "w": 12,
    "x": 0,
    "y": 0
  },
  "id": 2,
  "legend": {
    "avg": false,
    "current": false,
    "max": false,
    "min": false,
    "show": true,
    "total": false,
    "values": false
  },
  "lines": true,
  "linewidth": 1,
  "links": [],
  "minSpan": 12,
  "nullPointMode": "null",
  "percentage": false,
  "pointradius": 5,
  "points": false,
  "renderer": "flot",
  "repeat": "TRV",
  "repeatDirection": "h",
  "seriesOverrides": [
    {
      "alias": "TwinsTRV - Valve",
      "yaxis": 2
    },
    {
      "alias": "TRV Valve",
      "yaxis": 2
    },
    {
      "alias": "TRV SP",
      "yaxis": 1
    },
    {
      "alias": "Valve",
      "yaxis": 2
    },
    {
      "alias": "Landing TRV valve",
      "yaxis": 2
    },
    {
      "alias": "Landing Valve%",
      "yaxis": 2
    }
  ],
  "spaceLength": 10,
  "stack": false,
  "steppedLine": false,
  "targets": [
    {
      "alias": "$TRV TRV SP",
      "groupBy": [
        {
          "params": [
            "name"
          ],
          "type": "tag"
        }
      ],
      "measurement": "thermostat_changes",
      "orderByTime": "ASC",
      "policy": "default",
      "refId": "C",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "heatSetpoint"
            ],
            "type": "field"
          }
        ]
      ],
      "tags": [
        {
          "key": "name",
          "operator": "=~",
          "value": "/TRV$/"
        },
        {
          "condition": "AND",
          "key": "folder",
          "operator": "=",
          "value": "Heat Rads"
        },
        {
          "condition": "AND",
          "key": "name",
          "operator": "=~",
          "value": "/$TRV/"
        }
      ]
    },
    {
      "alias": "$TRV Stat SP",
      "groupBy": [
        {
          "params": [
            "name"
          ],
          "type": "tag"
        }
      ],
      "hide": false,
      "measurement": "thermostat_changes",
      "orderByTime": "ASC",
      "policy": "default",
      "query": "SELECT \"state.temperatureInput1\" FROM \"thermostat_changes\" WHERE $timeFilter GROUP BY \"name\"\n",
      "rawQuery": false,
      "refId": "A",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "heatSetpoint"
            ],
            "type": "field"
          }
        ]
      ],
      "tags": [
        {
          "key": "name",
          "operator": "=~",
          "value": "/stat$/"
        },
        {
          "condition": "AND",
          "key": "folder",
          "operator": "=",
          "value": "Heat Rads"
        },
        {
          "condition": "AND",
          "key": "name",
          "operator": "=~",
          "value": "/^$TRV/"
        }
      ]
    },
    {
      "alias": "$TRV Valve%",
      "groupBy": [
        {
          "params": [
            "name"
          ],
          "type": "tag"
        }
      ],
      "measurement": "device_changes",
      "orderByTime": "ASC",
      "policy": "default",
      "refId": "B",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "brightness"
            ],
            "type": "field"
          }
        ]
      ],
      "tags": [
        {
          "key": "name",
          "operator": "=~",
          "value": "/valve$/"
        },
        {
          "condition": "AND",
          "key": "folder",
          "operator": "=",
          "value": "Heat Rads"
        },
        {
          "condition": "AND",
          "key": "name",
          "operator": "=~",
          "value": "/$TRV/"
        }
      ]
    },
    {
      "alias": "$TRV Temp TRV",
      "groupBy": [
        {
          "params": [
            "name"
          ],
          "type": "tag"
        }
      ],
      "measurement": "thermostat_changes",
      "orderByTime": "ASC",
      "policy": "default",
      "refId": "D",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "state.temperatureTrv"
            ],
            "type": "field"
          }
        ]
      ],
      "tags": [
        {
          "key": "name",
          "operator": "=~",
          "value": "/stat$/"
        },
        {
          "condition": "AND",
          "key": "folder",
          "operator": "=",
          "value": "Heat Rads"
        },
        {
          "condition": "AND",
          "key": "name",
          "operator": "=~",
          "value": "/$TRV/"
        }
      ]
    },
    {
      "alias": "$TRV Temp Remote",
      "groupBy": [
        {
          "params": [
            "name"
          ],
          "type": "tag"
        }
      ],
      "hide": false,
      "measurement": "thermostat_changes",
      "orderByTime": "ASC",
      "policy": "default",
      "refId": "E",
      "resultFormat": "time_series",
      "select": [
        [
          {
            "params": [
              "state.temperatureRemote"
            ],
            "type": "field"
          }
        ]
      ],
      "tags": [
        {
          "key": "name",
          "operator": "=~",
          "value": "/stat$/"
        },
        {
          "condition": "AND",
          "key": "folder",
          "operator": "=",
          "value": "Heat Rads"
        },
        {
          "condition": "AND",
          "key": "name",
          "operator": "=~",
          "value": "/$TRV/"
        }
      ]
    }
  ],
  "thresholds": [],
  "timeFrom": null,
  "timeShift": null,
  "title": "$TRV Heating",
  "tooltip": {
    "shared": true,
    "sort": 0,
    "value_type": "individual"
  },
  "type": "graph",
  "xaxis": {
    "buckets": null,
    "mode": "time",
    "name": null,
    "show": true,
    "values": []
  },
  "yaxes": [
    {
      "format": "celsius",
      "label": "Temp",
      "logBase": 1,
      "max": null,
      "min": "-10",
      "show": true
    },
    {
      "format": "percent",
      "label": "Valve",
      "logBase": 1,
      "max": "400",
      "min": null,
      "show": true
    }
  ],
  "yaxis": {
    "align": false,
    "alignLevel": null
  },
  "scopedVars": {
    "TRV": {
      "selected": false,
      "text": "Landing",
      "value": "Landing"
    }
  }
}
Attachments
Screenshot 2018-12-02 at 21.13.49.png
Screenshot 2018-12-02 at 21.13.49.png (95.48 KiB) Viewed 494 times

Posted on
Sun Dec 02, 2018 3:50 pm
siclark offline
Posts: 1375
Joined: Jun 13, 2017
Location: UK

Re: Dashboard for thermostats

Just realised I haven't specified what states to enable. If it's not obvious from the Json I'll have a look and update tomorrow.

Posted on
Mon Dec 03, 2018 8:25 am
vtmikel offline
Posts: 511
Joined: Aug 31, 2012
Location: Boston, MA

Re: Dashboard for thermostats

Nice job. I've also set up temperature readings from many of my rooms, and graphed the "heatSetPoint" and "coolSetPoint" using a different style. It's a useful graph. I now notice the temperature differences between my rooms (also taking into consideration the location of my sensors - some are high up, and near windows).

Posted on
Thu Sep 17, 2020 9:34 am
CBowles offline
User avatar
Posts: 16
Joined: Mar 19, 2015

Re: Dashboard for thermostats

Hi Si,

Nice work on the heating dashboards for Heatmiser. I've been working on some for myself but I don't seem to be getting the "state.temperatureInput1" metrics from Indigo into Influx/Grafana.
The only metrics that it picks up from 'thermostat_changes' are:

coolSetpoint
deviceTypeId
heatSetpoint
id
model
name

Did you have the same issue initially? If so, how did you get round it?
At the moment, I have having an Indigo schedule writing the device states to a variable and reading them from there!

Cheers,

Chris
--

Posted on
Thu Sep 17, 2020 12:05 pm
siclark offline
Posts: 1375
Joined: Jun 13, 2017
Location: UK

Re: Dashboard for thermostats

I think you need to go into the Grafana plugin and add it to the feed there. I don’t remember the exact details, it’s been a while.

Posted on
Fri Sep 18, 2020 6:20 am
CBowles offline
User avatar
Posts: 16
Joined: Mar 19, 2015

Re: Dashboard for thermostats

Hi Si,

Many thanks for your prompt reply!
I found it in the end, there are default values Included and any that aren't you need to go to Configure in the plugin and add the states or the whole device for inclusion.
Then low and behold, the values are ingested!

C--

Posted on
Fri Sep 18, 2020 7:50 am
siclark offline
Posts: 1375
Joined: Jun 13, 2017
Location: UK

Re: Dashboard for thermostats

Great.. sorry I coulnt point you in exactly the right place but glad you got there.

Simon

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest