How do I sort heatmap by sum of row values? Want hottest to be up

Grafana Prometheus
1
  • Grafana v11.3.1, Ubuntu
    Prometheus v3.0.0

I have information about count of errors on more than 1000 of live video streams. It is a table: stream name / minute. I want to see what are the most problematic streams and it seems that good idea will be to sort amount of errors during a period and sort streams by amount of errors on all columns in each row.

So I want to order rows by sum of values in them, not by labels and apply heatmap visualisation.

Is it possible?

Right now I see only ordering by labels, looks like it is designed so that label order is natural. It is not my case.

2

checkout the transformation, there is a sort there, you can pick the column to sort on and the order, and if you want to sort on multiple columns, add multiple sorts…

1 Like
3

Maybe it is suitable for table view? Is it possible to apply tranformation to table and later transform it to the heatmap?

4

To sort a heatmap by the sum of row values, you can:

  1. Calculate the row sums: Compute the sum of each row.
  2. Sort the rows: Sort the rows in descending order based on their sum values.
  3. Reorder the heatmap: Apply this sorted order to the heatmap rows, so the hottest (highest sum) rows appear at the top.

If using Python (e.g., with Seaborn or Matplotlib), you can sort the data frame by row sums before plotting the heatmap.