How to do a pivot table in grafana

I have my test results stored in elasticsearch. I am trying to put a summary table in dashboard which will show me type of test, total testcases, #passed, #failed, #skipped. I tried the table panel where I am able to get the total testcases count. But I am not able to get the #passed, #failed and #skipped counts as columns in the table. Is there a way to do it in grafana

1 Like

What is the DB you are using… First group the passed,failed and skipped column then in transformation tab try ’ [Add field from calculation]. this will calculate #passed, #failed and #skipped counts