Merge row with same value in table

[yuswanulherlan]

Hi there,

so, i plan to merge some rows based on same value.

as you can see there are a few rows that have same timestamp. and i want to merge them based on the same timestamp. due to the value of Status field is variative, therefore I decided to combine them based on timestamp. That way, I can display the data from the latest to the oldest. can you tell me how to achieve it? Thank you

[jangaraj]

That deduplication should be done on the datasource level usually. Check doc of used datasource how can you deduplicate (e.g. using DISTINCT for SQL query), so Grafana will receive already deduplicated data.