How can I sorting heatmap field ( No Calculate from data) by using query?

Grafana Dashboards
1

  • What Grafana version and what operating system are you using?
    Grafana v9.0.1 (14e988bd22) Windows 10 21H1

  • What are you trying to achieve?
    I’m trying to monitoring hosting providers network and compare which location is more stable to my ISP.

  • How are you trying to achieve it?
    Using Blackbox-exporter and Prometheus record TCP & ICMP jobs and use the “probe_duration_seconds” metrics to generate a heatmap.

  • What happened?
    The heatmap perform well in each field, but it sort alphabetically by the label name I assigned in legend.

  • What did you expect to happen?
    I want to know is there any possible to sort the each field by some query like Sum over time or Avg over time to make result similar like this

    grafana-change-order
    grafana-change-order3044×737 107 KB

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?
    Slightly change this tutorial Replacing Smokeping with Prometheus - anarcat