# ELASTICSEARCH - Cumulative\_cardinality without histogram

**URL:** <https://discuss.elastic.co/t/elasticsearch-cumulative-cardinality-without-histogram/246322>\
**Category:** Elasticsearch\
**Created:** [August 25, 2020, 4:07pm UTC](https://discuss.elastic.co/t/elasticsearch-cumulative-cardinality-without-histogram/246322 "2020-08-25T16:07:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Miguel\_BA](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/miguel_ba/32/46926_2.png) [@Miguel\_BA](https://discuss.elastic.co/u/Miguel_BA)\
**Post date:** [August 25, 2020, 4:07pm UTC](https://discuss.elastic.co/t/elasticsearch-cumulative-cardinality-without-histogram/246322/1 "2020-08-25T16:07:41Z")

</div>

With this query I want to make a count of how many unique mobile phone numbers per company.

I have this query that returns the following error:

```auto
{"size": 1,
  "_source": "created_at", 
  "aggs": {
    "nested": {
      "nested": {
        "path": "data.addresses"
      },
      "aggs": {
        "phonefield": {
          "terms": {
            "field": "data.addresses.phone.keyword",
            "size": 100
          },
          "aggs": {
            "nested": {
              "nested": {
                "path": "data.addresses.services"
              },
              "aggs": {
                "mobilephone": {
                  "filter": {
                    "term": {
                       "data.addresses.services.mobilephone": "true"
                    }
                  },
                  "aggs": {
                    "company": {
                      "cardinality": {
                        "field": "data.addresses.services.company.keyword"
                      }
                     },
                     "total":{
                       "cumulative_cardinality": {
                         "buckets_path": "company"
                         }
                       }
                      }
                    },
                    "range":{
                      "top_hits": {
                        "size": 1,
                        "sort": [
                          {"created_at.keyword": {"order": "desc"}
                            
                          }
                        ]
                      }
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

```

Output

```auto
"Validation Failed: 1: cumulative_cardinality aggregation [total] must have a histogram, date_histogram or auto_date_histogram as parent;"

```

Would it be possible to obtain the total cumulative cardinility aggregation without a previous histogram?

---

<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 22, 2020, 4:07pm UTC](https://discuss.elastic.co/t/elasticsearch-cumulative-cardinality-without-histogram/246322/2 "2020-09-22T16:07:46Z")

</div>

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