How to calculate the average of an input when the value of another input is x, y or z in a timeseries

Grafana InfluxDB
1
  • What Grafana version and what operating system are you using?

Grafana v10.4.0 for Windows

  • What are you trying to achieve?

I want to calculate the average and total values of electricity consumption of a system that has varying states. I have both system state and consumption in a timeseries panel on my dashboard.

  • How are you trying to achieve it?

I am trying with additional queries and the classical expression.

image

Where B is my system state value and A is the electricity consumption.

  • What happened?

Nothing

  • What did you expect to happen?

When the system is in state X it should output the mean and total consumption for that specific period that the system was in state X. Same for the next state Y.

2

Welcome @thomasderuiter

I am afraid that what you describe may not be possible using InfluxQL. Have you explored using Flux or SQL? Both offer much more powerful functions that should allow you to achieve what you wish.

More here.

3

Hi @grant2, thank you for the fast reply!

I thought I was working in Flux to be honest, but I am new to this so I am not sure. This is the code I have so far:

from(bucket: “MyBucket”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “MyMeasurement”)
|> filter(fn: (r) => r[“_field”] == “system_state” or r[“_field”] == “E_cons”)

Now this works, it does show the two values in a time series. How can I use the Flux language to achieve my goal?

4

Hi @thomasderuiter

Can you run the above query in Influx Data Explorer (http://your-IP-address:8086) and paste the output here?

5

Hi @grant2

I could not access the link, I tried with my IP address. I went to the explorer within Grafana itself? This is the output I get there:

image
image521Ă—541 22.2 KB

6

Which version of Influx are you running? Is it installed on the machine where Grafana is installed?

7

@grant2 I do not think it is on my laptop, I access Grafana through my browser.

8

Hi @thomasderuiter

InfluxDB is a connected datasource for Grafana. If you are able to see Influx data in Grafana, then it is running somewhere (could be on prem or Cloud). It’s really tough to offer any guidance unless one can isolate the problem, and in this case, I think it means running the Flux query in Influx Data Explorer.

9

Hi @grant2 I suspect it is indeed running on Cloud, but I did not set up this whole structure and I am not an admin in this Grafana environment. Is there a way for me to get to this Influx Data Explorer when it is not running locally?

Thanks again, and sorry for the vagueness. It might just be better to contact the admin.

Thomas

1 Like