Hi, so like in the screenshot - but here it is again: |mstats max ("% Free Space") as "MB", max("Free Megabytes") as "FreeMB"
WHERE
index=m_windows_perfmon
AND
host=NTSAP10 span=1d by instance
|search instance!=hard*
|search instance!=_Total
|eval FreeDiskspace=round(FreeMB/1024,2)
|eval TotalDiskspace=round((FreeDiskspace/MB)*100,2)
|eval FullDiskspace=round(TotalDiskspace-FreeDiskspace,2)
|stats max("FreeDiskspace") as "Free Diskspace (GB)", max("FullDiskspace") as "Full Diskspace (GB)" by instance so it's metrics I'm trying to use for it . The free space and free megabytes metrics from my windows perfmon index. I exclude instances that have hard or total in it and then eval three versions of the diskspace. this way I have the free diskspace in gb, the total diskspace and the full, so used, diskspace. the free and the full(used) diskspace are the ones I'm having in the table, again as seen above, but when I try the pie chart it shows me not what I am looking for. I'd like to have pie charts for each instance which lets the pie chart show the free and used space together. right now it only shows me either of two things: - only the free or the full space per instance - all free spaces from all instances in one pie chart
... View more