Show just newest data in table panel

Grafana InfluxDB
1

Hi.
I want to show several rows in table panel. but i have one condition that even if i change time range from top right of dashboard, old data (rows) DOES NOT appear in my table. i should show the last set of rows anyway.
my data is like this for example: (i’m using telegraf and influxdb)

[{
	"row": "1",
	"State": "ESTAB",
	"Recv-Q": "13",
	"Send-Q": "0",
	"Local Address:Port": "",
	"Peer Address:Port": ""
}, {
	"row": "2",
	"State": "ESTAB",
	"Recv-Q": "87",
	"Send-Q": "11",
	"Local Address:Port": "",
	"Peer Address:Port": ""
}, {
	"row": "3",
	"State": "ESTAB",
	"Recv-Q": "0",
	"Send-Q": "50",
	"Local Address:Port": "",
	"Peer Address:Port": ""
}]

each item comes into one row.

It’s my pleasure if you have some solutions guys.
thanks.

2

Hi @amiram1

Can you show us what your data looks like in a table panel, and then describe for us how you want the data to look instead?

1 Like
3

Screenshot from 2021-07-31 11-15-58
Screenshot from 2021-07-31 11-15-581377×455 34.6 KB

just look at their times.

thanks @mattabrams

4

Can you show the query that you wrote which produces the above table of data?

1 Like
5

image

@grant2

6

thanks. I solved this issue by adding time to “now() - 1m” in query.