# Aggregation with collapsed query

**URL:** <https://discuss.elastic.co/t/aggregation-with-collapsed-query/303380>\
**Category:** Elasticsearch\
**Created:** [April 27, 2022, 9:50am UTC](https://discuss.elastic.co/t/aggregation-with-collapsed-query/303380 "2022-04-27T09:50:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ibrahim\_Z\_HIDIR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ibrahim_z_hidir/32/106875_2.png) [@Ibrahim\_Z\_HIDIR](https://discuss.elastic.co/u/Ibrahim_Z_HIDIR)\
**Post date:** [April 27, 2022, 9:50am UTC](https://discuss.elastic.co/t/aggregation-with-collapsed-query/303380/1 "2022-04-27T09:50:12Z")

</div>

Hi

I just want to apply aggregation on a query result. My query is eleminating the double documents keeping last one according to a clumn. But the aggragation doesn't care the actual result. I've read that the collapse doesn't affect the aggragation. I could't find a way to do that!

```auto
GET /db-oracle-kys-aktarim-*/_search?size=0
{
  "query": {
    "bool": {
      "must": [
        {"range": {"islemtarih":{"gte":"now/d"}}},
        {"match_phrase": {
           "islemyapan": "pasaport"
         }}
        ]
    }
  },
  "collapse": {
    "field": "kayitno"
  },
  "sort": [
    {
      "islemtarih": {
        "order": "desc"
      }
    }
  ],
  "from": 0, 
  "aggs": {
    "categories": {
      "terms": {
        "field": "aciklama.keyword"
      }
    }
  }
}

```

and the result is,

```auto
"aggregations" : {
    "categories" : {
      "doc_count_error_upper_bound" : 0,
      "sum_other_doc_count" : 0,
      "buckets" : [
        {
          "key" : "Baþarili",
          "doc_count" : 4598
        },
        {
          "key" : "Beklemede",
          "doc_count" : 4474
        }
      ]
    }
  }

```

but it must be,

```auto
"aggregations" : {
    "categories" : {
      "doc_count_error_upper_bound" : 0,
      "sum_other_doc_count" : 0,
      "buckets" : [
        {
          "key" : "Baþarýlý",
          "doc_count" : 4598
        },
        {
          "key" : "Beklemede",
          "doc_count" : 30
        }
      ]
    }
  }

```

because of doubled documents!

---

<div class="post-metadata">

**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\
**Post date:** [April 27, 2022, 8:54pm UTC](https://discuss.elastic.co/t/aggregation-with-collapsed-query/303380/2 "2022-04-27T20:54:15Z")

</div>

Do you have some examples of docs to simulate?

---

<div class="post-metadata">

**Author:** ![Ibrahim\_Z\_HIDIR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ibrahim_z_hidir/32/106875_2.png) [@Ibrahim\_Z\_HIDIR](https://discuss.elastic.co/u/Ibrahim_Z_HIDIR)\
**Post date:** [April 28, 2022, 12:18pm UTC](https://discuss.elastic.co/t/aggregation-with-collapsed-query/303380/3 "2022-04-28T12:18:10Z")

</div>

The documnts has same "kayitno" with date column "islemtarih" so I just want to keep latest doc for aggregation.

```auto
{
  "_index": "db-cc-kys-aktarim-000001",
  "_id": "tckk_2978351655",
  "_version": 1,
  "_score": 1,
  "_source": {
    "islemtur": 1,
    "islemtarih": "2022-04-28T06:59:06Z",
    "kysdurum": 1,
    "islemyapantc": xxxx,
    "tckimlikno": xxxx,
    "@version": "1",
    "kayitno": 2222222222,
    "islemyapan": "tckk",
    "aciklama": "Gönderilmedi",
    "basvurutarih": "2022-04-28T06:57:24Z",
    "tckkkayitno": 111111111,
    "@timestamp": "2022-04-28T06:59:10.558690800Z",
    "type": "kys-aktarim"
  },
  "fields": {
    "tckimlikno": [
      35806692548
    ],
    "islemyapan": [
      "tckk"
    ],
    "islemyapan.keyword": [
      "tckk"
    ],
    "@version.keyword": [
      "1"
    ],
    "type": [
      "kys-aktarim"
    ],
    "kysdurum": [
      1
    ],
    "islemtur": [
      1
    ],
    "aciklama": [
      "Gönderilmedi"
    ],
    "@timestamp": [
      "2022-04-28T06:59:10.558Z"
    ],
    "kayitno": [
      2978351654
    ],
    "type.keyword": [
      "kys-aktarim"
    ],
    "basvurutarih": [
      "2022-04-28T06:57:24.000Z"
    ],
    "@version": [
      "1"
    ],
    "islemtarih": [
      "2022-04-28T06:59:06.000Z"
    ],
    "aciklama.keyword": [
      "Gönderilmedi"
    ],
    "tckkkayitno": [
      335669560
    ],
    "islemyapantc": [
      88888888880
    ]
  }
}

{
  "_index": "db-cc-kys-aktarim-000001",
  "_id": "tckk_2978351654",
  "_version": 1,
  "_score": 1,
  "_source": {
    "islemtur": 1,
    "islemtarih": "2022-04-28T07:00:06Z",
    "kysdurum": 1,
    "islemyapantc": xxxx,
    "tckimlikno": xxxx,
    "@version": "1",
    "kayitno": 2222222222,
    "islemyapan": "tckk",
    "aciklama": "Gönderidi",
    "basvurutarih": "2022-04-28T07:00:05Z",
    "tckkkayitno": 111111111,
    "@timestamp": "2022-04-28T07:00:06Z",
    "type": "kys-aktarim"
  },
  "fields": {
    "tckimlikno": [
      35806692548
    ],
    "islemyapan": [
      "tckk"
    ],
    "islemyapan.keyword": [
      "tckk"
    ],
    "@version.keyword": [
      "1"
    ],
    "type": [
      "kys-aktarim"
    ],
    "kysdurum": [
      1
    ],
    "islemtur": [
      1
    ],
    "aciklama": [
      "Gönderidi"
    ],
    "@timestamp": [
      "2022-04-28T07:00:06Z"
    ],
    "kayitno": [
      2978351654
    ],
    "type.keyword": [
      "kys-aktarim"
    ],
    "basvurutarih": [
      "2022-04-28T06:57:24.000Z"
    ],
    "@version": [
      "1"
    ],
    "islemtarih": [
      "2022-04-28T07:00:06Z"
    ],
    "aciklama.keyword": [
      "Gönderilmedi"
    ],
    "tckkkayitno": [
      335669560
    ],
    "islemyapantc": [
      88888888880
    ]
  }
}

```

---

<div class="post-metadata">

**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\
**Post date:** [April 28, 2022, 1:11pm UTC](https://discuss.elastic.co/t/aggregation-with-collapsed-query/303380/4 "2022-04-28T13:11:50Z")

</div>

Try this:

```auto
 "aggs": {
    "categories": {
      "terms": {
        "field": "aciklama.keyword"
      },
      "aggs": {
        "unique_values": {
          "cardinality": {
            "field": "kayitno"
          }
        }
      }
    }
  }

```

> **[Cardinality aggregation | Elasticsearch Guide \[8.1\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-cardinality-aggregation.html)**

---

<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:** [May 26, 2022, 1:12pm UTC](https://discuss.elastic.co/t/aggregation-with-collapsed-query/303380/5 "2022-05-26T13:12:08Z")

</div>

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