How does one create a pie chart that would result in 3 equal pie slices?

[fdswitch]

I'm logging memory stats, and I have fields like "mem_free", "mem_used", and "mem_cache" that represent memory in MB.

Let's assume all three of these avg(fields) value is 33. How does one create a pie chart that would result in 3 equal pie slices?

[woodcock · Accepted solution]

Just add transpose, maybe something like this:

... | stats last(mem_*) AS mem_* | transpose

[cmerriman]

if they DON'T have equal values and, for whatever reason, you still want them to have equal slices, I'd create a dummy variable.

| stats last(mem_*) AS mem_* |transpose|eval column=column+" - "+'row 1'|eval sliceSize=33|fields - "row 1"

[fdswitch]

I'm not trying to force 3 equal slices, moderator changed my topic. But useful information none the less, thanks.