Grafana table query from mixed prometheus datasources shows multiple columns

Grafana Table Panel
1

  • What Grafana version and what operating system are you using?

    • Grafana 10.4.2, Linux

  • What are you trying to achieve?

    • Create table which shows CPU and Memory Utilization per cluster/datasource

  • How are you trying to achieve it?

    • Table panel → Mixed Datasource → Prometheus query

    • queries below -

    • label_replace(100- min_over_time(avg by (region) (rate(node_cpu_seconds_total{mode=“idle”}[1m]))[15d:]) * 100, “Cluster”, “mke5.devfg.com”, “”, “”)

      label_replace(max_over_time( ( 100 * (sum by (region) (node_memory_MemTotal_bytes) - sum by (region) (node_memory_MemAvailable_bytes))/ sum by (region) (node_memory_MemTotal_bytes))[15d:]), “Cluster”, “mke5.devfg.com”, “”, “”)

    • added transformation → inner join via cluster label, merge row/series, organize fields

  • What happened?