Ordering axes in a heatmap?

Grafana Dashboards
,
1

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.

20230727_12h43m30s_grim
20230727_12h43m30s_grim1483×372 23.1 KB

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

2

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

3

Hi,

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]))
5

Thanks,

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

1 Like