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.