sample pipeline aggregation

#!/usr/bin/env bash

curl "localhost:9200/crowdcontrol/_search?pretty&search_type=count" -d '{
    "query": {
        "term": {"roomId":"foyer"}
    },
    "aggs": {
        "byRoom": {
            "terms": {
                "field":"roomId"
            },
            "aggs": {
                "histo": {
                    "date_histogram": {
                        "field": "timestamp",
                        "interval": "5m",
                        "format" : "yyyy-MM-dd HH:mm:ss"
                    },
                    "aggs": {
                        "people_in_room": {
                            "sum": {
                                "field":"action"
                            }
                        },
                        "total_people_in_room": {
                            "cumulative_sum": {
                                "buckets_path": "people_in_room"
                            }
                        }
                    }
                }
            }
        }
    }
}'