Aggregation on specific object in an array

[Vivek_Burman]

Hi,
So my document has a structure as below. I would like to aggregate based on **value**, but only on the object with {"label": "Business Priority"}.
Can you help how I can achieve this?

[Tomo_M (Tomohiro Mitani)]

Hi,

If custom_fields is a nested field, use Nested aggregation.
The sample with a filter sub-aggregation, in the middle of the page below, might help you.

Nested aggregation | Elasticsearch Guide [8.6] | Elastic

[Vivek_Burman]

Using this payload.

{
    "size": 0,
    "aggs": {
        "agg_custom_field": {
            "nested": {
                "path": "custom_fields"
            },
            "aggs": {
                "root_filter": {
                    "filter": {
                        "bool": {
                            "filter": [
                                {
                                    "term": {
                                        "custom_fields.label": "Application Module"
                                    }
                                }
                            ]
                        }
                    },
                    "aggs": {
                        "agg_value": {
                            "terms": {
                                "field": "custom_fields.value"
                            }
                        }
                    }
                }
            }
        }
    }
}

Response is this

[Vivek_Burman]

This one worked

{
    "size": 0,
    "aggs": {
        "agg_custom_field": {
            "nested": {
                "path": "custom_fields"
            },
            "aggs": {
                "root_filter": {
                    "filter": {
                        "bool": {
                            "filter": [
                                {
                                    "match": {
                                        "custom_fields.label": "Application Module"
                                    }
                                }
                            ]
                        }
                    },
                    "aggs": {
                        "agg_value": {
                            "terms": {
                                "field": "custom_fields.value"
                            }
                        }
                    }
                }
            }
        }
    }
}