Learning Elastic Stack 6.0

Calculating the cumulative sum of usage over time

While understanding the Date Histogram aggregation and in the section Focusing on a specific day and changing intervals, we looked at the aggregation, to compute hourly bandwidth usage for one particular day. After completing that exercise, we had data for September 24^th with hourly consumption between 12 am to 1 am, 1 am to 2 pm, and so on. Using cumulative sum aggregation, we could also compute the cumulative bandwidth usage at the end of every hour of the day. Let's look at the query and try to understand it:

GET /bigginsight/usageReport/_search?size=0{  "query": {    "bool": {      "must": [        {"term": {"customer": "Linkedin"}},         {"range": {"time": {"gte": 1506277800000}}}      ]    }  },  "aggs": { "counts_over_time": ...