Grafana Table panel Filter data that columnA not equal columnB,how to do that

Grafana
1

I have a table panel,column A and column B are label of series.Then I want to filter the value of column A not equal column B. How to do that?
Another, how can I add column that can show the answer comparing ColumnA and CloumnB.

2

I find solution by transform with add field from calculation. Because column A and column B are strings,can’t use binary operation.Then I use Reduce row with distinct count.

1 Like