Pipeline Aggregations in Elasticsearch [ElasticSearch 7 for Beginners 5.3]

Thank you for this video. Can you please use sum in aggregation and then find avg for that sum there issue to calculate that value it will convert null value to 0 which giving incorrect average value for avg_bucket

Thank you for your video. Question: can you find, for example, all the buckets with average salary greater than or less than a specific value? For example, instead of finding the maximum, I find all the buckets with average salary > 5000