I would like to create a PIE chart only using the percentage for the ID's who are all completed how many number of certificates .
For example ,
ID No of Courses_completed
0112 3
0113 1
0114 2
0115 3
0116 0
Likewise I have 1000's of ID . Here I need to find out from total ID , 30% of them completed 2 courses , 40% of them completed 3 courses, 15 % of them completed 1 course, 15% of them not attended any course in PIE chart view. Kindly help to acquire this.
This will count number of IDs by the number completed
| stats count by "No of Courses_completed"
This will then show the segment with the count and percentage of each completed count
A pie chart will already show you a percent, so if you want to remove the count and only have percent add this after the stats
| eventstats sum(count) as Total
| eval Percent=round(count/Total*100, 2)
| table "No of Courses_completed" Percent
However, the pie chart will still show the percent, which will be the same as the Percent field here