Forum Discussion
Pie chart - Group together
Hello, I'm looking for a way to group together smaller enteties into a "other" category in pie chart
Here is a picture showing a portion of the data that is used as the input to the pie chart:
Here is what the pie chart looks now:
Here is what I want the pie chart to look like:
I would like the "three letter" codes that only appears once to be grouped together into a "other" category.
HI Anonymous ,
I'd like to suggest you add a calculated column with if statement to manually replace specific types to 'other', then you can use this column on the pie chart to group your records based on new category.
Category = VAR list = { "CAA", "EST", "FEX", "HJE", "JAU", "LGJ", "PAS", "SGT", "TRM" } RETURN IF ( Table[Instructor] IN list, "Other", Table[Instructor] )Regards,
Xiaoxin Sheng
1 Reply
HI Anonymous ,
I'd like to suggest you add a calculated column with if statement to manually replace specific types to 'other', then you can use this column on the pie chart to group your records based on new category.
Category = VAR list = { "CAA", "EST", "FEX", "HJE", "JAU", "LGJ", "PAS", "SGT", "TRM" } RETURN IF ( Table[Instructor] IN list, "Other", Table[Instructor] )Regards,
Xiaoxin Sheng