Date histogram for Bucket Aggregation

Hi,
I have a terms bucket aggregation on a field. is there a way to get the date histogram for each of the listed Bucket items received from terms aggregation.

Something like this. this isn't working but just to give the reference

{
    "query": {
        "bool": {
            "must": [ 
               SAMPLE_QUERY
            ]
        }
    },
    "aggs": {
        "category": {
            "terms": {
                "field": "category",
                "size": 200
            },
            "aggs": {
                "dates": {
                    "date_histogram":{
                        "field": "date",
                        "interval": "year",
                        "format": "yyyy"
                    }
                }
            }
        }
    }
}

from this, I'm expecting the Date histogram for each of the Bucket items that'll be returned.

Any suggestion will help greatly.

Thanks.

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