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?
That doesn’t make any sense. Can you show a mock-up of the desired result?
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%.
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.
1 Like
Instead of that I just want 6 main groups of percentages and all the percents that fall in those groups.
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.