Ordering axes in a heatmap?

I am trying to visualize utilization of cpu cores on a machine over time in a heatmap.
The values are between 0-1 in percent.

I would like the axes to be sorted numerically by the core numbers. How can this be done?

what is your data source and could you show us the query that produced this heatmap?


The source is prometheus which does not feature ordering by labels as far as I know.
This is the query used:

sum by (cpu) (rate(node_cpu_seconds_total{job="proxmox-server", mode!="idle"}[5m]))

Maybe use 2 transformations

  1. Convert that column to number
  2. Then use sort transformation


This worked. I also had to do a few more transformations but it worked.

1 Like