How to get the latest only records in table , using influxdb as datasource

[sureshdhanapahti]

hi , i have multiple sets of records like the following , im using Table panel in grafana , using the influx 1.7.8

site player name player Score
Site1 john 12
site2 Dennis 13
site3 walker 11
Site1 john 10
site2 Dennis 11
site3 walker 9

is it possible to show only the latest record for each site, i have tried limit option but it shows only the last 3 records not the latest

[malamgir]

How to get the latest value from range, based on time

Do you get it when not using override relative time? Does it make a difference changing it to 5m? Please refer to How To Use Grafana's Query Inspector to troubleshoot issues and include the complete request/response from query inspector. Have a look at time series aggregations documentation for table panel. Not really sure what you mean. The max is per given time unit if that makes sense, You group by date histogram which result in several max values per time unit. I would sugugest you to r…

[dhplf]

You can achieve this by combining last() and “group by”.
Something like…
SELECT last(score) from measurement group by *
…should work.

Use field values in the last()-function and tag values in group by.