Can we remove duplicate rows from the table?

hiteshkumar02 · March 16, 2022, 4:52am

Can we remove duplicate rows from the table?
with different timestamp.
version - Grafana v7.0.5
DB - Influxdb

mattabrams · March 16, 2022, 11:21pm

welcome to the forum, @hiteshkumar02

can you provide steps for reproduction? Sharing some sample data and how you want to change it will help the community a lot

expoenergy · March 17, 2022, 5:39am

To do this use the DISTINCT statement as shown below.

Topic		Replies	Views
Filter rows in table : Show rows value only if the previous value is different Grafana	4	3650	March 6, 2022
Table Panel: Filter and show data Table Panel influxdb , table-panel	19	17318	March 3, 2022
Merge rows by time same table InfluxDB	14	1998	November 20, 2022
How can I merge rows in a grafana table panel?	9	10391	January 23, 2021
Duplicate Rows in Table Table Panel	1	9372	January 17, 2018