Azure Log analytics simple pie chart

Question

I have a query like;

example_CL | where field1 == "name" | top 1 by TimeGenerated desc

Gives me the latest row with the latest value of "name" like;

name        quota   used
samplename  100     75 

I'm trying to make a donut chart which shows 75/100.

Answer 1

would this work?

datatable(field1:string, quota:int, used:int)
[
    "somename", 100, 75
]
| project used, unsued = quota - used
| evaluate narrow()
| project Column, toint(Value)
| render piechart