Order by Math Aggregation in TSVB Top N Visualisation

Hi,

I'm trying to use the Top N visualisation to obtain a list of hosts sorted by CPU usage descending. To do this, I am dividing CPU usage by the number of cores on the system using a pipeline math aggregation. However, I am then unable to sort by this aggregation:

Should I be going about this another way? I have a separate need to sort by a derivative aggregation, and that is not possible either.

Any help would be much appreciated.

Thanks.

Hi @bruce289
I've tested locally and I can confirm that this is not possible at the moment. Could you please open an enhancement request into the Kibana repo?

In the meantime I will investigate if there is a workaround