[Lens] Support for multiple breakdown by

[AlonaNadler]

A customer is looking to do multiple splits in visualizations, similar to what they currently do with Area visualization in Visualize.
When done in Visualize it creates multiple nesting combination fieldA - fieldB as a series

[elasticmachine]

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

[wylieconlon]

This is technically possible, but haven't we heard users complain about how confusing this feature of Visualize is? Is there a way we can provide it in Lens, but without the confusing parts? I would consider this an open question.

[AlonaNadler]

Opening it to track this request. This is still planned for the future. We want to allow users to breakdown by multiple level and allow them to chose whether to use split series or split chart

[georgewitteman]

This is technically possible, but haven't we heard users complain about how confusing this feature of Visualize is? Is there a way we can provide it in Lens, but without the confusing parts? I would consider this an open question.

What do you users say is confusing about this?

[th0ger]

Users (me) say, that Lens without multiple breakdown (split series) is severely limiting.
Especially because there is no split chart alternative to use.

[wylieconlon]

The main reason it's confusing in Visualize is that each Terms aggregation is ordered in a hierarchy, it's not flattened like in a SQL request.

We will most likely support a single extra breakdown, which is part of the implementation of small multiples that we are tracking separately. In every level of breakdown, we would allow multiple fields for the Top Values/Terms aggregation. These features would be powerful enough for all the requests I've seen, without overcomplicating the UI.

[ghudgins]

as of 8.1 you can now combine fields with multi field top values in Lens. we will keep this issue open to add multiple breakdown by (nested terms) and cover additional edge cases.

For those who posted on this issue, it would be good to know if 8.1's multi field top values support in lens satisfies your needs

[peder82]

I am interested in this. For example, breakdowns based on two parameters like operating system and manufacturer. Currently I use filter and breakdown, but to have both parameters included in breakdown would be very convenient.

[ghudgins]

@peder82 we added support to breakdown by combined fields in 8.1 - I think this covers your case!

[peder82]

@peder82 we added support to breakdown by combined fields in 8.1 - I think this covers your case!

Exactly what I want, thank you!

[kush-elastic]

Hey guys,
I was wonder if this works same as how visualizations works.
I am currently working on visualization to lens migration.
I have one visualization, which contains multiple split series where i have to showcase top five load for Top five hosts. which returns me total unique 25 series in which i will get top 5 hosts with its top five load values..
how can i create such visualization in lens?

[stratoula]

Lens already supports this in recent kibana versions