Creating a pipeline aggregation as given in the official doc using Kibana

Hi,

I am looking to create a visualization for the example given here

POST /_search
{
    "aggs": {
        "my_date_histo":{
            "date_histogram":{
                "field":"timestamp",
                "interval":"day"
            },
            "aggs":{
                "the_sum":{
                    "sum":{ "field": "lemmings" } 
                },
                "the_movavg":{
                    "moving_avg":{ "buckets_path": "the_sum" } 
                }
            }
        }
    }
}

Using my data I tried to get the request message as same as above. However the closest I could come to is to get the moving average of "_count". Sample image attached.
How do I create the visualization to mirror the same request as above?

-Thanks
Nikhil

Hello Nikhil,

You can change the Count from your second metric to a Sum instead of Count and then set the field that you want the sum for.

1 Like

Jeez, I dunno what I was thinking. Perhaps had a brain freeze. Thanks.

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