In Kibana's Vega, how can I create layers from two different aggs in one request-CodePudding

The

If we did this, having Vega do the calculation of the average:

{ "$schema": "https://vega.github.io/schema/vega-lite/v2.json", "title": "Hat Sales", "data": { "url": { "index": "hat-sales", "body": { "size": 0, "query": {"match_all": {}}, "aggs": {"stores": {"terms": {"field": "store.keyword", "size": 3}}} } }, "format": {"property": "aggregations.stores.buckets"} }, "transform": [ {"calculate": "datum.key", "as": "store"}, {"calculate": "datum.doc_count", "as": "count"} ], "layer": [ { "name": "Sales of top 3 stores", "mark": "bar", "encoding": { "x": {"type": "nominal", "field": "store", "sort": "-y"}, "y": {"type": "quantitative", "field": "count"} } }, { "name": "Average number of sales over all stores", "mark": {"type": "rule", "color": "red"}, "encoding": {"y": {"aggregate": "mean", "field": "count"}} } ] }

which would looks like this: then the horizontal rule would be an average of the top 3 stores only. Instead we need to add another metric aggregation to the Elasticsearch request which calculates the global average of hats sold at stores (