How to display the Total Space and Consumed in a single pie chart?

[bollam]

Hello, I have following content in the event and I want to display TotalSpace and ConsumedSpace in the single pie chart.
For an instance: if the TotalSpace is 1000 and the ConsumedSpace is 250 then the 1/4th of the pie should display as ConsumedSpace over TotalSpace.

Event:
This is total space is TotalSpace=2000
This is Available space is AvailableSpace=1000
Name="Bollam"

Query which I had written:
index=sai_core source="size" Name="Bollam" | eval ConsumedSpace = TotalSpace - AvailableSpace
| stats first(ConsumedSpace) as ConsumedSpace by TotalSpace

[kamlesh_vaghela]

Hi
Have you tried transpose command?

Can you please try this?

index=sai_core source="size" Name="Bollam" | head 1
| eval ConsumedSpace = TotalSpace - AvailableSpace 
| table ConsumedSpace AvailableSpace 
| transpose

Please try below sample search and set pie chart in viz.

| makeresults 
| eval TotalSpace=1000,AvailableSpace=250 
| eval ConsumedSpace = TotalSpace - AvailableSpace 
| table ConsumedSpace AvailableSpace 
| transpose

Thanks