Hi,
I would like to know if it's possible in some way, to visualize the next Elasticsearch query on a kibana metric or chart? I tried using JSON input but without a good result, and I don't know if it's the correct way.
GET _search
{
"query": {
"match_all": {}
},
"aggs": {
"per_day": {
"date_histogram": {
"field": "@timestamp",
"interval": "day"
},
"aggs": {
"MISS_Sum": {
"sum": { "field": "MISS" }
},
"HTTP_Sum": {
"sum" : {"field": "HTTP_Request"}
},
"Manifest_Sum": {
"sum": { "field": "Manifest_Request"}
},
"m3u8_Sum": {
"sum": {"field": "m3u8_Request"}
},
"Cache_MISS": {
"bucket_script": {
"buckets_path": {
"miss_sum": "MISS_Sum",
"http_sum": "HTTP_Sum",
"manifest_sum": "Manifest_Sum",
"m3u8_sum": "m3u8_Sum"
},
"script": "miss_sum / (http_sum - manifest_sum - m3u8_sum)"
}
}
}
}
}
}
The goal is to show the Cache_MISS value.
Thanks.