[Lens] Allow client-side bucket filtering of numbers by selecting the visible number range

[wylieconlon]

Context

The bucket selector aggregation is one of the most-upvoted Kibana feature requests, but the Elasticsearch feature is too complex to add to Lens because it uses Painless scripting. I am proposing that we simplify by limiting it to numbers only. The main use cases can be solved with a simple number range input, like "number is greater than 0" or "number is less than 100". This filtering needs to be done client side because it has to run after all calculations.

Examples

• Showing only positive values: this is the most common request
• Hiding any sessions under 1000 hours (requested in Add bucket_selector aggregation to visualizations #17544 )

Proposed functionality

Each numeric dimension will offer an advanced setting from the flyout editor to "select number range". This setting will be exposed as two number inputs representing the lower and upper bounds of the numbers. Only number that are inside the number range will be shown. So if the user selects that the lower bound is 1, and the upper bound is infinity, it will show positive numbers only.

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[ghudgins]

+1 https://discuss.elastic.co/t/visualize-library-pie-chart/286690/1

"only show >1000"

[flash1293]

@shahzad31 I'm hoping this feature can fix the legend problem with filtered metrics in a general way without introduce some magic or a special flag right now.

[SaraAlshamsi]

+1

[redcinelli]

+1

[gueri-fr]

+1

[smnschneider]

+1

[dej611]

This is already possible with ES|QL with the where command.