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

[ave]

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!

[grant2]

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

[ave]

Hi, I’m currently using Influx.

[grant2]

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).