Create a pie chart based on counts of values?
We have four of five different attributes we apply to our projects to group them by (e.g. IT/Digital/Engineering/Sustainment). I would like to create a pie chart that shows the percentage of projects per criteria. So we might have 30% "Engineering" projects vs. 40% "IT" projects. But I can only seem to create a pie chart based on fields with numbers. Is there any way to create a pie chart as I described?
Great question! You can create a pie chart based on the count of values by first grouping by a field in your table other than the Record ID (you are only presented with the number fields as the Data if you do not change this first field).
1. In the Pie Chart settings, in the drop-down list for 'Name (label)', choose the field that is storing the project type/group.
2. Check the box labeled 'Group by this field' that appeared.
3. Choose a field under 'Data (piece of pie)' (this could be the same field as step 1).
4. In the drop-down menu next to the Data field where you see 'Summary function', choose one of the 'COUNT' options.
These steps should allow you to create a pie chart that displays the percentage of projects in each group.