Visualize fields as percentage in pie chart

[harryvdtol]

Hello,

I have 3 rows with numeric data, trying to visualize this in a pie chart.

The first value (totalval) is the total value
I want to the other values to be a percentage of the total value and so only show the 2 other values (typeA and typeB)

type           total
---------------------
totalval    4151
typeA       1442
typeB        17

Trying for some hours, i am stuck, any help is appreciated

Regards,

Harry

[ITWhisperer · Accepted solution]

| eval totalval=if(type="totalval",total,null())
| eventstats values(totalval) as totalval
| where type!="totalval"
| eval percent=100*total/totalval

[harryvdtol]

Very impressive and educational.

Thank you.

Regards,

Harry