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