Arranging x axis by value of y axis for a formula field

I'm creating a tree map lens visualization. I have a field "account name" under "group by" and have a formula (absolute value) on a number field "Delta value" under "size by". When I try to rearrange the order of the "group by" it only gives me an alphabetical choice and not by the "size by" field. Any idea how this can be done? thanks

Hi @behappy_alwayz0401 ,

it is currently not possible to rank top values by a formula, as the latter will be computed only at client side level and the server would not know how to retrieve the value to rank by.

On the other hand you can track this issue about client side sorting which will mitigate the problem in the future: [Lens] Allow client-side sorting of dimensions and legends at datasource level for all chart types · Issue #86184 · elastic/kibana · GitHub

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.