# Kibana table sum of count and timeseries count for given host

**URL:** https://discuss.elastic.co/t/kibana-table-sum-of-count-and-timeseries-count-for-given-host/310629
**Category:** Kibana
**Created:** [July 26, 2022, 11:04am UTC](https://discuss.elastic.co/t/kibana-table-sum-of-count-and-timeseries-count-for-given-host/310629 "2022-07-26T11:04:32Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![PRASHANT\_MEHTA](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant_mehta/32/101764_2.png) [@PRASHANT\_MEHTA](https://discuss.elastic.co/u/PRASHANT_MEHTA)
#### Post date: [July 26, 2022, 11:04am UTC](https://discuss.elastic.co/t/kibana-table-sum-of-count-and-timeseries-count-for-given-host/310629/1 "2022-07-26T11:04:32Z")

</div>

Hello All,

I want to display above two visuals based on below table.As for now above two visuals are wrong,but desired in same style.  
Whenever there is an error it should display the translator name and total count of error for given translator,same should be shown through time series.For time series it required number metric and dont work on string.  
The "error" filed is a string value.(Above two visuals are to be created based on error filed)  
Buckets aggregation is done on a filed translator\_taskid i.e unique.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/a/3a7a0c57bb193bbefabba1afd731511758ecdbd1.png)

Any suggestion would be helpful.

Many thanks

---

<div class="post-metadata">

### Author: ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)
#### Post date: [August 12, 2022, 8:03am UTC](https://discuss.elastic.co/t/kibana-table-sum-of-count-and-timeseries-count-for-given-host/310629/2 "2022-08-12T08:03:48Z")

</div>

For the first visual:

1. let's assume that the `Cancelled` is `Error` field and `Carrier` is `Translator` field. You can achieve the visualization by setting a filter for the whole visualization (`Error: true` or whatever string it is) and create something like:  

2. 

 ![Screenshot 2022-08-12 at 10.03.30](https://us1.discourse-cdn.com/elastic/original/3X/c/6/c6e658206faa7c41f7d0d79c71b210dcd6088465.jpeg)

---

<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: [September 9, 2022, 8:04am UTC](https://discuss.elastic.co/t/kibana-table-sum-of-count-and-timeseries-count-for-given-host/310629/3 "2022-09-09T08:04:48Z")

</div>

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