Home Assistant InfluxDB parameter formatting

Installation Home Assistant OS
1

Hello,

I’m having some difficulties using https://github.com/hassio-addons/addon-influxdb together with https://www.home-assistant.io/components/influxdb/#sensor .

I’ve got it all working with simple queries, but I’m struggling with the gaps in the documentation.

This query in my configuration.yaml file works fine and the sensor appears:

 queries:
    - name: Greenhouse Temperature
      unit_of_measurement: °C
      group_function: mean
      where: '"device" = ''Greenhouse'''
      measurement: '"BrynyneuaddSensors"'
      field: Temperature

However when I try to convert it to something more useful by grouping, it fails:

 queries:
    - name: Greenhouse Temperature
      unit_of_measurement: °C
      group_function: time(1h)
      where: '"device" = ''Greenhouse'''
      measurement: '"BrynyneuaddSensors"'
      field: Temperature

Can anyone help with the syntax here - can’t see anything in the docs other than very basic formatting, here’s my query that validates and works in Grafana/InfluxDB:

SELECT mean("Temperature") FROM "BrynyneuaddSensors" WHERE ("device" = 'Greenhouse') AND $timeFilter GROUP BY time(1h) fill(null) LIMIT 100