Aggregate pie chart by percent

[Eric_Woodhouse]

I am looking to have an aggregate pie chart but I want the totals to display as < 60% and 60-70%, 70-80%, 80-90%, 90-100%, any ideas how I would do that?

[Marc_Dillon]

That doesn't make any sense. Can you show a mock-up of the desired result?

[Eric_Woodhouse]

I have a bunch of records that have a percent field in them, 72%, 65%, 88% and so on. I dont want to show the exact percent in the pie chart but just groups, 59% and below, 60- 69%, 70-79%, 80-89%, 90-100%. 

[Marc_Dillon]

You could convert the exact percentage into a range group with an expression in another column, using IFS()

https://help.appsheet.com/en/articles/2355961-ifs

But I still have no idea how you expect the visualization to look.

[Eric_Woodhouse]

Instead of that I just want 6 main groups of percentages and all the percents that fall in those groups.

[Eric_Woodhouse]

This is what im looking for 

Instead of height it would be sorted by percent range.

[Marc_Dillon]

Do the conversion mentioned above, per record.

Then create a histogram, with the new percent_group column, and set the aggregate to whatever you're wanting to show, like COUNT, for number of records.