# Building Visualization Table

**URL:** <https://discuss.elastic.co/t/building-visualization-table/131228>\
**Category:** Kibana\
**Created:** [May 9, 2018, 9:18pm UTC](https://discuss.elastic.co/t/building-visualization-table/131228 "2018-05-09T21:18:54Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)\
**Post date:** [May 10, 2018, 6:02pm UTC](https://discuss.elastic.co/t/building-visualization-table/131228/2 "2018-05-10T18:02:37Z")

</div>

Getting the pass/fail percentage in the result can be achieved with a scripted field. I outlined a similar solution [in this thread](https://discuss.elastic.co/t/convert-string-results-into-failure-rates/131227/2), you'd simply use a different field and match for the value (`pass` instead of `SUCCESS`).

Once you have that value mapping, you can create a table vis using the average of that field.

Filtering that list by domains that have one or more pass values is the hardest part, and I can't think of a way to do that. This means the end result may have domains with a `0%` result. You can limit the number by controlling the size of the terms aggregation on the domain value though, so you don't see a giant list of all the domains.

---

_[View the full topic](https://discuss.elastic.co/t/building-visualization-table/131228)._
