InfluxDB sum last points

Question

I have a measurement of the player counts on multiple game servers, every time a player leaves or joins the server, the server writes a point to influx containing the player count and the server's unique id.

What I am trying to do is sum the last point for each unique server id.

example points:

04:30 server-a: 45
04:31 server-b: 56
04:32 server-a: 78

the current total would be: 134

I have been able to get the last points for each server with the following query.

from(bucket: "metrics")
  |> range(start: -1m)
  |> filter(fn: (r) => r._measurement == "player_count")
  |> last()

Any help would be greatly appreciated :)

Beowolve · Accepted Answer · 2021-08-25T11:53:37.503

2

You need to group your data and then sum it. Add this to your influx query:

|> group()
|> sum()

edited Aug 25 '21 at 11:53

answered Aug 25 '21 at 11:46

Beowolve

548
2
13

Ah, I was playing with the group function but I never tried to just leave it empty! Thanks! – Marshall Walker Aug 25 '21 at 11:52
Exactly what I needed thanks. Also added `|> last()` prior to apply the operation on only the last set of points. – Joe Still Oct 06 '22 at 14:43

InfluxDB sum last points

1 Answers1