Hello, I am running Influx 1.8 (and Grafana 7) on a Raspberry PI 4. Among other things, Influx receives datapoint from our electric vehicle when it drives or is getting charged. Influx receives data into various ‘measurements’, for example one measurement (with timestamp) each for latitude, longitu…

@Jens If Flux is connected and you can verify that you have data in InfluxDB with cURL or the InfluxDB API, then I’m afraid this might be a question for [image] Grafana Labs Community Forums Official Grafana Labs community forums. Get technical support for open source Grafana, Loki, and…

Hi Jens, Nice to meet you digitally and an interesting use case btw. So let’s break the problem down and see what we can achieve together. Firstly I think the function you are looking for can be achieved in Flux and this is called cumulativesum . Before we get to that point we need to prepare your d…

Hello Jay, and - wow, thank you for your elaborate answer. I really need to get into Flux, it seems to be much more than just a query language. Currently I use InfluxQL mostly from Grafana, and this is my first problem: how do I get Flux support installed? I use Grafana 7.0.3, do I need to upgrade…

Hi Jens, No problem at all. We like an interesting use case here at Influx so this is really took my fancy :slight_smile:. So yes for your combination you would need to update to Grafana 7.1. Your Influx version is fine but Flux query needs to be enabled. To do this follow these instructions . Can …

Hello Jay, I took the challenge and “updated” to Grafana 7.1.5 today in the hope that the upgrade will be smooth (it was) and that I can use Flux now (I can’t). I set “flux-enabled = true” in the influxdb.conf as described in the handbook, but then Influxdb doesn’t start up any more and requests t…

Hi Jens, Ah sorry to hear this. Can you send me a copy of your influxdb.conf

[meta] dir = “/var/lib/influxdb3/meta” [data] dir = “/var/lib/influxdb3/data” wal-dir = “/var/lib/influxdb3/wal” wal-fsync-delay = “10s” index-version = “tsi1” query-log-enabled = false max-concurrent-compactions = 1 [coordinator] write-timeout = “20s” [retention] [shard-precreation] [m…

Hi Jens, How large is your InfluxDB instance? This might be the cause and solution to the issue: [image] Influxdb 1.8.7 will not start InfluxDB 1 I had the same issue just yesterday. It seems they changed something in the startup script in version v1.8.9, the same one we …

Actually, changing “sleep 1” to “sleep 5” helped do the trick as well. Thank you! Now I can configure Flux connections to InfluxDB and these are successful. However, no Flux query - even the simplest example queries - return any results in Grafana’s Data Explorer. There is an error if I stop influ…

Hi Jens, I am ever so sorry for not getting back to you sooner. I missed the notification for your last message. Have you checked in your Grafana instance that you are using Flux? Please see below when creating Data Source: [Screenshot 2021-10-08 at 10.53.54]

Yes, Flux is enabled and I can submit Flux queries. There is actually a log entry in the influx request log (which, strangely, contains SQL-like code… but what do I know). But I never get any results. The result set is always empty.

Grouping measurements by location (lat/lng measurement) and value

InfluxDB 1 InfluxQL

Jay_Clifford October 4, 2021, 10:02am 8

Hi Jens,
How large is your InfluxDB instance? This might be the cause and solution to the issue:

Topic		Replies	Views
How to get a cumulative sum of a product from different series? InfluxQL influxql , query	21	1528	April 15, 2024
How to convert InfluQL to Flux with GROUP BY and WHERE Fluxlang influxdb , query , flux	1	429	January 20, 2022
One data point with a string and a value Welcome & Getting Started	5	680	March 27, 2020
Flux: Get total energy by month with an ever-increasing value InfluxDB 2 influxdb , time-series , grafana , query , flux	8	5007	January 18, 2023
Multiply two field values and store the result in a new field	22	11907	June 9, 2020

Grouping measurements by location (lat/lng measurement) and value

Related topics