Question

You want to create a Kibana dashboard showing average transaction duration per service over the last day. Which Elasticsearch query aggregation setup supports this?

Accepted Answer

{ "size": 0, "query": { "range": { "@timestamp": { "gte": "now-1d" } } }, "aggs": { "services": { "terms": { "field": "service.name.keyword" }, "aggs": { "avg_duration": { "avg": { "field": "transaction.duration.us" } } } } } }

Answer

{ "size": 10, "query": { "match_all": {} }, "aggs": { "avg_duration": { "avg": { "field": "transaction.duration.us" } } } }

Answer

{ "size": 0, "query": { "range": { "transaction.duration.us": { "gte": "now-1d" } } }, "aggs": { "services": { "terms": { "field": "service.name" } } } }

Answer

{ "size": 0, "query": { "range": { "@timestamp": { "gte": "now-1d" } } }, "aggs": { "avg_duration": { "avg": { "field": "service.name.keyword" } } } }

You want to create a Kibana dashboard showing average transaction duration per service over the last day. Which Elasticsearch query aggregation setup supports this?

Step 1: Filter data for the last day

Step 2: Aggregate by service name keyword

Step 3: Calculate average transaction duration per service

Final Answer:

Quick Check:

Want More Practice?