[Lens] Display last n values

[maximekuntz]

We can currently display on a lens the $n$ first values of a field (in a breakdown) e.g. the 6 top values on the following image.

Could we have the same to display the last $n$ values ?

[elasticmachine]

Pinging @elastic/kibana-visualizations @elastic/kibana-visualizations-external (Team:Visualizations)

[stratoula]

@maximekuntz the top values depend on the ranking you are selecting. Check the elasticsearch documentation here https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html#search-aggregations-bucket-terms-aggregation-order

In your example you are ranking them alphabetically (ordering by the term value). If you order them by the metric then it will return the top n terms ordered by this metric. If you change this to ascending it will sort the terms by the lowest first and return the top n.

Ordering is not guaranteed to return correct results as you see in the documentation. You can improve by enabling the accuracy setting.

But maybe I don't understand your request correctly. What do you mean with the last n values?

[maximekuntz]

@stratoula You are right, I did not detail the exact point.

Let consider the following example: we have terms, A, B, C, D, E, F, G, H, I, J.
Currently, we can sort in ascending order and take the top 6 value. It returns (in this order): A, B, C, D, E, F.

And if I sort in descending order and take the top 6 value, it returns (in this order): J, I, H, G, F, E.

I would like to have E, F, G, H, I, J i.e. displayed in ascending (alphabetical) order.

I hope it is clearer.

[dej611]

I think this is a duplicate of #86184 then.
In Lens it is only possible to "rank" Top values data, then the visualization will render with the same order as in the data response. The linked issue is about providing more control on UI sorting of the data.

[stratoula]

Got it! This is not possible atm but we have an issue open for that #86184 (allow client side sorting per dimensions). I think this is going to solve this case. I wil close this issue in favor of the one I posted. Thanx for explaining!