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.