Timezone Problem at Import InfluxDB data as sensor in Home Assistant

Configuration
,
1

Hi, I am using InfluxDB as my history Database and want to get Some Informations as Sensor entity.

This is documented here: InfluxDB - Home Assistant

Problem is, that Home Assistant store the Data to InfluxDB in UTC. On InfluxDB Dashboard, I am using the following Command to get the correct values.

import "timezone"

option location = timezone.location(name: "Europe/Berlin")

This is working fine.

My example yaml Code:

- platform: influxdb
  host: !secret influxdb_host
  ssl: false
  port: !secret influxdb_port
  api_version: 2
  token: !secret influxdb_token
  organization: !secret influxdb_org
  bucket: !secret influxdb_bucket
  queries_flux:
    - imports:
        - timezone
      range_start: "today()"
      name: "Gasverbrauch heute von InfluxDB"
      unit_of_measurement: kWh
      unique_id: influxdb_gasverbrauch_heute
      query: >
        filter(fn: (r) => r["entity_id"] == "gas_zahlerstand_kwh")
        |> filter(fn: (r) => r["source"] == "HA")
        |> filter(fn: (r) => r["_field"] == "value")
        |> filter(fn: (r) => r["_measurement"] == "kWh")
        |> filter(fn: (r) => r["domain"] == "sensor")
        |> aggregateWindow(every: 1d, fn: spread, createEmpty: false)
        |> tail(n: 1, offset: 0)

But I can not add the option location parameter to my yaml query. How can I solve this problem?

1 Like
2

Would love to understand this as well!

3

Seems like quite a lot of functions in Flux have an optional parameter ‘location’ where you can specify the timezone. Caveat is that you have to apply it in every function separately.
In your example, range_start would become something like:

range_start: date.truncate(t: now(), unit: 1d, location: {zone: "Europe/Berlin", offset: 0h})

and for aggregateWindow it would become:

aggregateWindow(every: 1d, fn: spread, createEmpty: false, location: {zone: "Europe/Berlin", offset: 0h})

I used something similar and it seems to do the trick.