Help with Grafana using Prometheus datasource

Grafana Prometheus
1

Hi all. I’ve been trying to figure out a way to calculate percentage in Grafana using Prometheus datasource.
Alert metric in Prometheus is pretty simple
100 * (node_free_bytes{device=~“/dev.+”,job=“sql server”} /node_size_bytes{device=~“/dev.+”,job=“sql server”})

These are each row for free_bye and size_byte. They both have the same size of rows

Screen Shot 2021-07-14 at 1.24.45 AM

I want a table like this (or 4 gauges virtualization). Which is percentage each row for each table

Screen Shot 2021-07-14 at 1.24.49 AM

It wasn’t a big deal if the table has only 4 rows. But I want to find a proficiency way for a big table. Please help

2

Try this:
(node_free_bytes{job=“sql server”} / node_size_bytes{job=“sql server”}) * 100

Then fill the Legend : {{device}}