Display metrics for multiple instances

Grafana Alerting
, ,
1

Hi All,

I have requirement for node exporter dashboard to display metrics for multiple instances : (will select multiple instances from dropdown and it will display data for multiple nodes )

Quick CPU / Mem / Disk row of Node Exporter Dashboard :
It has CPU Busy, SysLoad (5m ) ,RAM Used , SWAP Used , Root FS Used , CPU Cores and Uptime as panels

I able to fetch the required things for RAM Used , SWAP Used, Uptime :

But CPU Busy, SysLoad (*m ) CPU Cores doesnt work :slight_smile:
I tried with sum by and grouping with instance still no luck :

Here are the queries

CPU Busy :
(((count(count(node_cpu_seconds_total{instance=~"$instance",job=~"$job"}) by (cpu))) - avg(sum by (mode)(irate(node_cpu_seconds_total{mode=‘idle’,instance=~"$instance",job=~"$job"}[5m])))) * 100) / count(count(node_cpu_seconds_total{instance=~"$instance",job=~"$job"}) by (cpu))

Sys Load (5 m)

avg(node_load5{instance=~"$instance",job=~"$job"}) / count(count(node_cpu_seconds_total{instance=~"$instance",job=~"$job"}) by (cpu)) * 100

CPU Core

count(count(node_cpu_seconds_total{instance=~"$instance",job=~"$job"}) by (cpu))

Please suggest .or if anyone has worked on the similar requirement let me know

2

I have fixed it , it might help someone

(((count by (instance)(count(node_cpu_seconds_total{instance=~"$instance",job=~"$job"}) by (cpu,instance)))-avg(sum by (mode,instance)(irate(node_cpu_seconds_total{mode=‘idle’,instance=~"$instance",job=~"$job"}[5m]))) by (instance)) * 100 ) / count by (instance)(count(node_cpu_seconds_total{instance=~"$instance",job=~"$job"}) by (cpu,instance))

Sys Load

avg(((node_load5{instance=~"$instance",job=~"$job"}))) by (instance) / count by (instance)(count(node_cpu_seconds_total{instance=~"$instance",job=~"$job"}) by (instance,cpu) ) * 100

CPU Cores:

count by (instance)(count(node_cpu_seconds_total{instance=~"$instance",job=~"$job"}) by (instance,cpu))