topic Re: Visualize fields as percentage in pie chart in Dashboards & Visualizations

Visualize fields as percentage in pie chart

harryvdtol — Wed, 19 Jan 2022 12:22:03 GMT

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

Re: Visualize fields as percentage in pie chart

ITWhisperer — Wed, 19 Jan 2022 13:00:53 GMT

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

Re: Visualize fields as percentage in pie chart

harryvdtol — Wed, 19 Jan 2022 13:19:23 GMT

Very impressive and educational.

Thank you.

Regards,

Harry