Grouping of values

Hi Guys,

I am having a table which looks somewhat like this.

I just want to show the latest/last Value for each distinct Connection. Is it possible to write any query for this? The database used is InfluxDB and visualization is done in Grafana.
Note: tag_keys = [“Name”]

Cheers,
SD

Is “Connection” a tag? if yes maybe a simple
SELECT last(Value) FROM db.rp.mes WHERE ___ GROUP BY "Connection" will return waht you ask for.

in any case can you provide the desired output and something more about your tag/field structure?

1 Like

Hi @Giovanni_Luisotto,

It wasn’t. so I made “Connection” a tag and it works now! Thanks for the response.

Cheers,
SD

1 Like