What Grafana version and what operating system are you using? Grafana 9.3.2 What are you trying to achieve? Visualize in a bar graph the weekly consumption based on daily values for one month How are you trying to achieve it? import “timezone” option location = timezone.location(name: “E…

Alright @dieterlind , I think this 8+ day journey is about to cross the finish line… How about this? import "date" import "timezone" import "date/boundaries" // need to import this to use the next function firstWeek = boundaries.week(week_offset: -4) // may need -5 here....not totally sure thisWe…

what do you see when you run this query in influx itself? please post screen shot if possible? and how are you writing to influxdb and are you sure the dates are utc?

yep. and does it show accurately in influxdb explorer?

[image] yosiasz: and how are you writing to influxdb and are you sure the dates are utc? you have not answered this critical question

I write to influxdb via iobroker-adapter Not quiet sure if the dates are really utc. How can I find out? And no, in influxdb explorer it is also not correct

Check iobroker adapter config maybe for time settings or server is is being run on etc Run it in debug mode or see what it is dumping test mode to test bucket and compare to real utc

[image] dieterlind: import “timezone” option location = timezone.location(name: “Europe/Berlin”) Could also be :point_up:t6::point_up:t6:

just checked the settings in iobroker-adapter: nothing to set there regarding time server itself shows the right time timedatectl Local time: Wed 2023-06-14 08:50:08 CEST Universal time: Wed 2023-06-14 06:50:08 UTC when I run it without timezone-settings I receive [image] with timezone-setti…

as additional information: When I just evaluate the last value per day everything is OK: [image] so it has something to do with the sum over one week

[image] dieterlind: |> aggregateWindow(every: 24h, fn: last, createEmpty: false) Is there a reason you chose in the above line 24h instead of 1d?

Influxdb2: Combining last + sum to get weekly values

Grafana InfluxDB

dieterlind June 13, 2023, 6:17pm 3

you mean that:

Daily totals precipitation

Topic		Replies	Views
Summary and representation of daily to calendar monthly values InfluxDB dashboard	40	2156	July 22, 2024
Total Consumption summed up Last 7 days (not working) Bar Gauge Panel influxdb , bar-gauge , flux	3	1627	October 22, 2022
Total daily energy use Configuration	25	11585	May 9, 2022
Wrong value in graph with bars	37	21845	March 29, 2020
InfluxDB2 Power Consumption Group by Month ?!? InfluxDB	16	5177	February 23, 2024

Influxdb2: Combining last + sum to get weekly values

Related topics