Allow multiple categories to be grouped manually in a pie chart

Idea created by tom.rippetoe on Oct 17, 2018
    New
    Score90
    • KateW_BOPRC
    • arepsher
    • tom.rippetoe
    • minottDev
    • clintchev
    • mowbraya
    • achipman_crec
    • derek.phyn_WRC
    • mkerr

    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).