Freedman-Diaconis histogram

[GopherJ]

Sometimes it can be hard to choose histogram interval, Freedman-Diaconis rule is a good example to calculate number of bins to have better distributions, sadly it's not supported in elasticsearch

[elasticmachine]

Pinging @elastic/es-analytics-geo (:Analytics/Aggregations)

[polyfractal]

Would be nice I agree!

Similar to #50386 and #50120, I think this would require multi-pass agg support because we'd need a single pass over the data to determine the IQR first, then a second pass to bucket the documents.

Could expose a parameter if the user provides the IQR and count, but that's not very user-friendly.

Side note: the new variable width histogram might interest you, and we're planning to do an "auto-histogram" (#31828) similar to auto-date-histo which merges together buckets using some kind of deterministic scheme (powers of 10 or something). Not as nice as something like Freedman-Diaconis, but possible to do in a single pass.

Cheers for the request! Will keep this in mind as we consider multi-pass aggs!

[wchaparro]

This is not something we plan to implement in the near future in aggregations, and has been superceded by our focus on ESQL. Closing as not planned. If your feel strongly about this one, please let us know.