Merging two rows in to a single row using Grafana Table Panel

Grafana Configuration
1

Hi,

I am using ‘InfluxDB’ as data source and my requirement is to create a comparison table. I have below two rows in my influxdb

image

Need to convert this in to a single row that compares the data in two rows

image

Is this something achievable using Table panel in Grafana or any other ways to achieve this in Grafana.

Note: For representation in the second screenshot, I have used First row LCP column as “LCP_Current” and Second Row LCP column as “LCP_Previous”

2

Might this be what you are looking for?