# Error in table widget with sum biucket agg

**URL:** <https://discuss.elastic.co/t/error-in-table-widget-with-sum-biucket-agg/159730>\
**Category:** Kibana\
**Created:** [December 6, 2018, 1:04pm UTC](https://discuss.elastic.co/t/error-in-table-widget-with-sum-biucket-agg/159730 "2018-12-06T13:04:30Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![1862347ba9566e72a47d](https://avatars.discourse-cdn.com/v4/letter/1/cdc98d/32.png) [@1862347ba9566e72a47d](https://discuss.elastic.co/u/1862347ba9566e72a47d)\
**Post date:** [December 6, 2018, 1:04pm UTC](https://discuss.elastic.co/t/error-in-table-widget-with-sum-biucket-agg/159730/1 "2018-12-06T13:04:31Z")

</div>

It is necessary to build a table in a kibana, where aggregation by sum is used when building. The field(term) on which the table is built is not in all documents of the index. In table first add a "Filters" bucket with 1 filter "\*" , then add a "Terms" bucket (field).  
When use Sum Bucket with subAgg Terms by custom metric sum & aggregation by count I get the following error  
`Request to Elasticsearch failed: {"error":{"root_cause":[{"type":"illegal_argument_exception","reason":"buckets_path aggregation does not exist for aggregation [15]: 15-bucket&gt;_count"}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"index_1","node":"node_1","reason":{"type":"illegal_argument_exception","reason":"buckets_path aggregation does not exist for aggregation [15]: 15-bucket&gt;_count"}}],"caused_by":{"type":"illegal_argument_exception","reason":"buckets_path aggregation does not exist for aggregation [15]: 15-bucket&gt;_count","caused_by":{"type":"illegal_argument_exception","reason":"buckets_path aggregation does not exist for aggregation [15]: 15-bucket&gt;_count"}}},"status":400}`

When I remove "Filters" bucket with 1 filter "\*", the error disappears. And aggregation works correctly. How to fix the error?  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/d/5d383fd13d78e229e2b3583cbd1e6498213b4380.png)

---

<div class="post-metadata">

**Author:** ![ppisljar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ppisljar/32/11588_2.png) [@ppisljar](https://discuss.elastic.co/u/ppisljar)\
**Post date:** [December 6, 2018, 1:08pm UTC](https://discuss.elastic.co/t/error-in-table-widget-with-sum-biucket-agg/159730/2 "2018-12-06T13:08:39Z")

</div>

could you please provide a screenshot of your whole configuration ?

thank you

---

<div class="post-metadata">

**Author:** ![1862347ba9566e72a47d](https://avatars.discourse-cdn.com/v4/letter/1/cdc98d/32.png) [@1862347ba9566e72a47d](https://discuss.elastic.co/u/1862347ba9566e72a47d)\
**Post date:** [December 6, 2018, 2:01pm UTC](https://discuss.elastic.co/t/error-in-table-widget-with-sum-biucket-agg/159730/3 "2018-12-06T14:01:38Z")

</div>

Buckets

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/6/46dedc7f1ecbe35ef62a5cd31e496806e9df6c74.png)  
Metrics  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/c/bc0f61c93f7706de10eff5c05af336afd14c0595.png)

---

<div class="post-metadata">

**Author:** ![ppisljar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ppisljar/32/11588_2.png) [@ppisljar](https://discuss.elastic.co/u/ppisljar)\
**Post date:** [December 6, 2018, 2:29pm UTC](https://discuss.elastic.co/t/error-in-table-widget-with-sum-biucket-agg/159730/4 "2018-12-06T14:29:58Z")

</div>

i am not able to reproduce this.

what version of kibana are you using ?  
please copy paste whole url

---

<div class="post-metadata">

**Author:** ![1862347ba9566e72a47d](https://avatars.discourse-cdn.com/v4/letter/1/cdc98d/32.png) [@1862347ba9566e72a47d](https://discuss.elastic.co/u/1862347ba9566e72a47d)\
**Post date:** [December 6, 2018, 2:47pm UTC](https://discuss.elastic.co/t/error-in-table-widget-with-sum-biucket-agg/159730/5 "2018-12-06T14:47:09Z")

</div>

Kibana Version: 6.4.2

---

<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:** [January 3, 2019, 2:51pm UTC](https://discuss.elastic.co/t/error-in-table-widget-with-sum-biucket-agg/159730/6 "2019-01-03T14:51:20Z")

</div>

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