# Kibana metric aggregation - sum distinct **URL:** \ **Category:** Kibana\ **Created:** [March 26, 2019, 3:45pm UTC](https://discuss.elastic.co/t/kibana-metric-aggregation-sum-distinct/173962 "2019-03-26T15:45:49Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Francisca\_Lima](https://avatars.discourse-cdn.com/v4/letter/f/edb3f5/32.png) [@Francisca\_Lima](https://discuss.elastic.co/u/Francisca_Lima)\ **Post date:** [March 26, 2019, 3:45pm UTC](https://discuss.elastic.co/t/kibana-metric-aggregation-sum-distinct/173962/1 "2019-03-26T15:45:49Z")
Hello, I want to use Elasticsearch and my idea is to access my SQL database and with a query join all the data that I have in my database. I solve this problem and now I am trying to do some visualizations. My data: x1, x2, x3 term1, 10, 56 term1, 20, 56 term1, 12, 56 term2, 10, 67 term2, 12, 67 I want to have the sum of x3 but only have 1 time the x3 value for x1, like: x1, x3 term1, 56 term2, 67 To do this, I can use a sum bucket aggregation of x1 and calculate average of x3, for each x1. Now, I want to sum x3 and have value 123 (56+67). My problem is here! How can I do this? Here is the metric aggregation I made: ![Inkedvalues_LI](https://us1.discourse-cdn.com/elastic/original/3X/7/5/75588bda0bfeb8a9b66ea2a9364c2e1513d89238.jpeg) Thank you, Francisca ---
**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\ **Post date:** [March 27, 2019, 3:27pm UTC](https://discuss.elastic.co/t/kibana-metric-aggregation-sum-distinct/173962/2 "2019-03-27T15:27:16Z")
Hey @Francisca_Lima, you can do this using a configuration similar to the following: ![43%20AM](https://us1.discourse-cdn.com/elastic/original/3X/d/b/db6c7b7f207ba5d4ef187aa1f79d756c241ba1a7.png) ---
**Author:** ![Francisca\_Lima](https://avatars.discourse-cdn.com/v4/letter/f/edb3f5/32.png) [@Francisca\_Lima](https://discuss.elastic.co/u/Francisca_Lima)\ **Post date:** [March 27, 2019, 3:50pm UTC](https://discuss.elastic.co/t/kibana-metric-aggregation-sum-distinct/173962/3 "2019-03-27T15:50:09Z")
The problem is that the size is limited to 10000. ---
**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\ **Post date:** [March 27, 2019, 3:52pm UTC](https://discuss.elastic.co/t/kibana-metric-aggregation-sum-distinct/173962/4 "2019-03-27T15:52:19Z")
> The problem is that the size is limited to 10000. Would you mind clarifying what limit you're referring to? ---
**Author:** ![Francisca\_Lima](https://avatars.discourse-cdn.com/v4/letter/f/edb3f5/32.png) [@Francisca\_Lima](https://discuss.elastic.co/u/Francisca_Lima)\ **Post date:** [March 28, 2019, 9:53am UTC](https://discuss.elastic.co/t/kibana-metric-aggregation-sum-distinct/173962/5 "2019-03-28T09:53:28Z")
I want to aggregate x1 to have the value of the metric. However, the maximum size is 10 000. ![Capturar](https://us1.discourse-cdn.com/elastic/original/3X/b/5/b5cc94cdd188218f6634b7519e20ba57454d7849.png) ---
**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\ **Post date:** [March 28, 2019, 1:42pm UTC](https://discuss.elastic.co/t/kibana-metric-aggregation-sum-distinct/173962/6 "2019-03-28T13:42:28Z")
That limit is for the number of "buckets" do you have over 10,000 distinct values for x1? ---
**Author:** ![Francisca\_Lima](https://avatars.discourse-cdn.com/v4/letter/f/edb3f5/32.png) [@Francisca\_Lima](https://discuss.elastic.co/u/Francisca_Lima)\ **Post date:** [March 28, 2019, 3:40pm UTC](https://discuss.elastic.co/t/kibana-metric-aggregation-sum-distinct/173962/7 "2019-03-28T15:40:31Z")
x1 is the identification code, so I have more than 10 000 distinct values. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 25, 2019, 3:40pm UTC](https://discuss.elastic.co/t/kibana-metric-aggregation-sum-distinct/173962/8 "2019-04-25T15:40:59Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.