I Want to make a Table in real time CPU Usage

Grafana Prometheus
,
1

  • What Grafana version and what operating system are you using?
    Grafana v10.3.3 (252761264e)
    Promethus 2.50.1
    Ubuntu 20.04(With Docker)

  • What are you trying to achieve?
    Want to Make a real time Server Status Dash Board

Hi, I’m new in Grafana and PromQL

I Want to make a Real Time Server Status Dashboard like below:

image
image800×320 15.7 KB

I Use Query below for get Current CPU status:

Column 1
sort_desc( 100 - ( avg by (alias) ( irate( node_cpu_seconds_total{job=~“$System”, mode=“idle”}[$__rate_interval] ) )* 100 ) )

and set format to “Table” and Type to “Range”

as i did, grafana show me like this.

image
image1166×432 40.6 KB

how can i modify this table like the picture above?

2

Hi,

I’d use Partition by values transformation (by alias field I guess) and then join by Time field (not tested though and there might be some easier way like Prepare Time Series transformation, but I’m not too experienced with that one).