# How to show total count and percentage of error records in a table?

**URL:** <https://discuss.elastic.co/t/how-to-show-total-count-and-percentage-of-error-records-in-a-table/134918>\
**Category:** Kibana\
**Created:** [June 7, 2018, 7:46am UTC](https://discuss.elastic.co/t/how-to-show-total-count-and-percentage-of-error-records-in-a-table/134918 "2018-06-07T07:46:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![firdshai](https://avatars.discourse-cdn.com/v4/letter/f/87869e/32.png) [@firdshai](https://discuss.elastic.co/u/firdshai)\
**Post date:** [June 7, 2018, 7:46am UTC](https://discuss.elastic.co/t/how-to-show-total-count-and-percentage-of-error-records-in-a-table/134918/1 "2018-06-07T07:46:58Z")

</div>

Hi,  
I have created a data table visualization and I am taking count as metric. Now I want more columns where I wish to take error count and percentage as metric which will give me the count and percentage of the respective error count value for the rows. Kindly suggest if it can be possible.

---

<div class="post-metadata">

**Author:** ![chrisronline](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chrisronline/32/28230_2.png) [@chrisronline](https://discuss.elastic.co/u/chrisronline)\
**Post date:** [June 7, 2018, 3:03pm UTC](https://discuss.elastic.co/t/how-to-show-total-count-and-percentage-of-error-records-in-a-table/134918/2 "2018-06-07T15:03:55Z")

</div>

Hi @firdshai,

Can you elaborate more on your data? What do your mappings look like? I'm not sure what you mean when you say `error count` and `percentage`

---

<div class="post-metadata">

**Author:** ![firdshai](https://avatars.discourse-cdn.com/v4/letter/f/87869e/32.png) [@firdshai](https://discuss.elastic.co/u/firdshai)\
**Post date:** [June 8, 2018, 4:25am UTC](https://discuss.elastic.co/t/how-to-show-total-count-and-percentage-of-error-records-in-a-table/134918/3 "2018-06-08T04:25:14Z")

</div>

Hi,

I want to get total error count and its percentage.  
Suppose I have 10 records in which 4 fails due to error to whom I am calling error records so this count and its equivalent percentage which will be 40%.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2018, 4:33am UTC](https://discuss.elastic.co/t/how-to-show-total-count-and-percentage-of-error-records-in-a-table/134918/4 "2018-07-06T04:33:46Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.