elasticsearchVehicleUtilizationScript.json

GET events/_search
{
  "size": 0,
  "query": {
    "bool": {
      "filter": {
        "bool": {
          "must": [
            {
              "range": {
                "eventTime": {
                  "gte": "2019-04-01T00:00:00.000Z",
                  "lte": "2019-04-08T00:00:00.000Z"
                }
              }
            },
            {
              "term": {
                "_asset": "5b1e98fe3dacb21138ca6bd4"
              }
            },
            {
              "terms": {
                "_projects": [
                  "5a54e1744ebe60a2de00974c",
                  "5ae078e1d4f4cf01c8170c10",
                  "5afbf9fae5741f292c056d34"
                ]
              }
            }
          ]
        }
      }
    }
  },
  "aggs": {
    "group_by_day": {
      "date_histogram": {
        "field": "eventTime",
        "interval": "day",
        "order": {
          "_key": "desc"
        }
      },
      "aggs": {
        "per_asset": {
          "terms": {
            "field": "_asset.keyword"
          },
          "aggs": {
            "max_lifetimeOdometerInMeters": {
              "max": {
                "field": "lifetimeOdometerInMeters"
              }
            },
            "min_lifetimeOdometerInMeters": {
              "min": {
                "field": "lifetimeOdometerInMeters"
              }
            },
            "diff_lifetimeOdometerInMeters": {
              "bucket_script": {
                "buckets_path": {
                  "maxValue": "max_lifetimeOdometerInMeters",
                  "minValue": "min_lifetimeOdometerInMeters"
                },
                "script": "params.maxValue - params.minValue"
              }
            },
            "sum_fuelConsumed": {
              "sum": {
                "field": "fuelConsumed"
              }
            },
            "max_speed": {
              "max": {
                "field": "speedInMps"
              }
            },
            "max_engineRPM": {
              "max": {
                "field": "engineRPM"
              }
            },
            "max_engineCoolantTemperature": {
              "max": {
                "field": "engineCoolantTemperature"
              }
            },
            "avg_ecoScore": {
              "avg": {
                "field": "ecoScore"
              }
            },
            "harshEvents": {
              "terms": {
                "field": "harshDrivingType.keyword"
              }
            }
          }
        }
      }
    }
  }
}