Metrics with Formula Doesn't appear in "RANK BY" option in LENS

Hello Team,

I'm currently working on setting up a tabular dashboard in LENS. I'm in the process of defining variables within the "Metrics" option. However, when I choose the TOP Value for the Rows field, I notice that only single-variable metrics are appearing. Metrics with formulas are not available for selection under the RANK BY option.

Hi @Arshukla

this is currently not possiblem you can track this feature request for future development: [Lens] sort by a formula column without expanding the entire range · Issue #114951 · elastic/kibana · GitHub