It is possible to calculate something like avg(a) + avg(b) group by c

Elastic Stack Elasticsearch
1

I don't know how to make my explanation, for example in sql

SELECT c,avg(a) + avg(b) as count FROM name group by c;

It is possible to write using in elasticsearch? Thanks!

2

I do think so (my SQL skills are very rusty after years of Elasticsearch), but a terms aggregation with two nested avg aggregations might be what you are searching for.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.