Filter rows in table : Show rows value only if the previous value is different

Hello everyone,

I would like to know how I could filter rows on the tables of grafana with the following rules
“add a new row to the panel only if the current value is different than the previous one”

A direct example :

My current table :

times value A value B
6pm 12 meters 5 s
5pm 15 meters 6 s
4pm 17 meters 6 s
3pm 17 meters 7 s
2pm 17 meters 7 s

What i would like to have is the following :

times value A value B
6pm 12 meters 5 s
5pm 15 meters 6 s
4pm 17 meters 6 s
2pm 17 meters 7 s

It filters the following rows : 3pm | 17 meters | 7 s because : each case are the same than the previous one at 2pm (except the time of course)

Thanks!

What type of datasource are you using (Influx, SQL, etc.)?

1 Like

Hi, I’m currently using Influx.

I am not sure one can (in a straightforward manner) remove a duplicate row of data using Grafana. Maybe check the Influx forum and see how to handle it using the Distinct function (maybe this post from several years ago will help). If the query can indeed be built using Influx, then I would expect it could be placed in the Overrides box as shown below and then Grafana would not include that duplicate row of data when making your graph (but the data would still exist in Influx).
Override