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
| eval totalval=if(type="totalval",total,null())
| eventstats values(totalval) as totalval
| where type!="totalval"
| eval percent=100*total/totalval
| eval totalval=if(type="totalval",total,null())
| eventstats values(totalval) as totalval
| where type!="totalval"
| eval percent=100*total/totalval
Very impressive and educational.
Thank you.
Regards,
Harry