Allow multiple categories to be grouped manually in a pie chart

792
4
10-17-2018 09:46 AM
Status: Open
Occasional Contributor III

I'd like the ability to manually include multiple categories into a single slice in a pie chart. Currently categories can only be grouped together based on a minimum percentage threshold (for example, all categories with less than 5% of total can be grouped). 

One specific use case for this request is based on data generated from Survey123.  In our survey we have a multiple choice question. when multiple options are selected, Survey123 stores the selections as a comma separated list. According to esri tech support there is a known bug in Survey123 such that the options are not always listed in the same order. For example, if options A, B and C are selected, Survey123 could store the data as "A,B,C" or "B,A,C", or "C,B,A" and so on.  Each of those values are really the same thing, but if you create a pie chart with that data, you will get 3 separate slices.  I want to group those three values/categories into a single slice to correctly represent the data.

Another example that comes to mind - a survey of middle school students and the extra-curricular act ivies might include answers like:  track, basketball, drama club, art club, book club, jazz band, marching band, chess club, cooking club, none, etc.  I'd like to be able to group those many options into broad categories like Sports, Art, etc.  The pie chart with a few broad level categories, as opposed to many individual slices would be much nicer (i think).

4 Comments

I'm all for this idea, and I'd even propose extending this to all chart types.

Does anyone know if Esri did any updates to this?

This would be useful for category selectors also. Being able to manually group options would be helpful for all of the widgets.

I agree this would be helpful. You can group symbology values in ArcGIS Desktop, so same idea would be helpful here with Dashboards on the various charts. I have a project right now that it would have been helpful for the Pie Chart. 

The only way to accomplish this now would be to add new fields and edit the data to the grouping you want.