Grafana Pie Chart with prometheus datasource

Hello,

i am using grafana v8.0.5 and as Datasource i use Prometheus.I want to monitor the DB Storage of MSSQL and displaying the result in Pie Chart.I also use a custom MSSQL DB Exporter and for monitoring the storage i use a query which returns this outcome to me:

grafik

I use below metrics :

mssql_db_size_used_total
mssql_db_size_used_storage

What i am looking for,is a Pie Chart like this(Microsoft Azure Portal).Here is shown the Total Size and Used Size in GB and %.
grafik

So i tried to get a similar Chart in grafana
grafik

The Value in GB looks fine,but the Percent doesn’t.I don’t understand why the Total percentage is subtracted?I don’t use any arithmetic operation here.

For me it looks like a limitation of grafana.Unfortunately on grafana documentation i did not find any example of Pie Chart using Prometheus as datasource.
Any hint is welcome.

In order to get this to look just the way you like, I might try using a series of transformations, including the add field from calculation feature:

1 Like