Hey All,
I have a question around chart data - so I've pulled back a set of data that has lets say 30 different values. Its obviously not very feasible to do this in a pie chart as you end up with a ton of labels that make up jibberish. Is there a way in the chart to say select the top 5 or 10 and then group everything else into an 'other' designation? The only way I can think of to do this manually is to create a new row and then give it a condition to run through all 30 values and then use that as a chart option but I was wondering if there was a better way to where I didn't have to do that. I know I could use a different chart that shows more valued better but am needing to do this in a pie chart and essentially group 20-25 values into one value to make the pie chart usable. Any suggestions? Thanks!
I have a question around chart data - so I've pulled back a set of data that has lets say 30 different values. Its obviously not very feasible to do this in a pie chart as you end up with a ton of labels that make up jibberish. Is there a way in the chart to say select the top 5 or 10 and then group everything else into an 'other' designation? The only way I can think of to do this manually is to create a new row and then give it a condition to run through all 30 values and then use that as a chart option but I was wondering if there was a better way to where I didn't have to do that. I know I could use a different chart that shows more valued better but am needing to do this in a pie chart and essentially group 20-25 values into one value to make the pie chart usable. Any suggestions? Thanks!