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”]
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?
It wasn’t. so I made “Connection” a tag and it works now! Thanks for the response.