Is there a way to group values in a chart? Such as to show values that meetsa certain criteria vs those that don't

Question

I'm trying to create a donut chart showing the percentage of records that meet a certain criteria (e.g. all records with a cell value <10) and the percentage that don't meet that criteria (all records with a cell value >10). Is there a way to do this within Insights without additional data processing or do I need to create a new column and calculate pass/fail of the criteria and symbolize that? Once I have calculated the criteria, how do show it as a percentage?

Scott_Aulen · Accepted Answer

@SaraHedrick1,

For your first question, I would recommend creating an additional column using a Logical Function in the calculate field dialog.

For your second question, we don't currently have a mechanism for labelling percentage within a donut chart but that's a great idea and I would encourage you to add it to the Ideas board so we can prioritize.