# Is it possible query for summed up cardinalities?

**URL:** https://discuss.elastic.co/t/is-it-possible-query-for-summed-up-cardinalities/65983
**Category:** Elasticsearch
**Created:** [November 14, 2016, 1:22pm UTC](https://discuss.elastic.co/t/is-it-possible-query-for-summed-up-cardinalities/65983 "2016-11-14T13:22:30Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![luka](https://avatars.discourse-cdn.com/v4/letter/l/a587f6/32.png) [@luka](https://discuss.elastic.co/u/luka)
#### Post date: [November 14, 2016, 1:22pm UTC](https://discuss.elastic.co/t/is-it-possible-query-for-summed-up-cardinalities/65983/1 "2016-11-14T13:22:30Z")

</div>

I use Cardinality Aggregation in a query. Is it possible modify the query such that the response also contains the sum of those counts?

---

<div class="post-metadata">

### Author: ![danielmitterdorfer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/danielmitterdorfer/32/110510_2.png) [@danielmitterdorfer](https://discuss.elastic.co/u/danielmitterdorfer)
#### Post date: [November 14, 2016, 2:11pm UTC](https://discuss.elastic.co/t/is-it-possible-query-for-summed-up-cardinalities/65983/2 "2016-11-14T14:11:42Z")

</div>

Hi @luka,

the cardinality aggregation is a single-value aggregation, i.e. it produces only a single value. What do you want to sum up? Can you show a concrete example?

Nevertheless, if you want to sum the results of an aggregation, you can use the [sum bucket pipeline aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/master/search-aggregations-pipeline-sum-bucket-aggregation.html).

Daniel

---

<div class="post-metadata">

### Author: ![luka](https://avatars.discourse-cdn.com/v4/letter/l/a587f6/32.png) [@luka](https://discuss.elastic.co/u/luka)
#### Post date: [November 14, 2016, 2:36pm UTC](https://discuss.elastic.co/t/is-it-possible-query-for-summed-up-cardinalities/65983/3 "2016-11-14T14:36:09Z")

</div>

Hi @danielmitterdorfer,

The aggregation was only the last one in a series of nested aggregations, so your guessed my case correctly. Thank you!

ps I am still at version 1.7 and didn't know about pipelines.

---

<div class="post-metadata">

### Author: ![danielmitterdorfer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/danielmitterdorfer/32/110510_2.png) [@danielmitterdorfer](https://discuss.elastic.co/u/danielmitterdorfer)
#### Post date: [November 14, 2016, 2:38pm UTC](https://discuss.elastic.co/t/is-it-possible-query-for-summed-up-cardinalities/65983/4 "2016-11-14T14:38:24Z")

</div>

Hi Luka,

> [@luka](#):
>
> ps I am still at version 1.7 and didn't know about pipelines.

Oh, I assumed you were at least on 2.x. Note that pipeline aggregations have been added in Elasticsearch 2.0, so unfortunately, you cannot use them.

Daniel

---

<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: [December 12, 2016, 2:38pm UTC](https://discuss.elastic.co/t/is-it-possible-query-for-summed-up-cardinalities/65983/5 "2016-12-12T14:38:23Z")

</div>

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