Group data in categories, then show the weight of each data group as a percentage of total

[rladrond]

I have an app where users rate shows. Rates go from 1 to 5 -I use the Star-Value input.

I want to show the data grouped by rate, then as a weight percentage within the total amount of rates.

Example:

“Show A” has 10 different ratings from 1 to 5:

5-5-5-5-4-4-4-3-3-2

So, there are 4 5-star ratings; 3 4-star ratings; 2 3-star ratings, 1 2-star rating; 0 1-star rating.

Therefore:

40% give a 5-star rating;
30% give a 4-star rating;
20% give a 3-star rating;
10% give a 2-star rating;
0% give a1-star rating.

Question is: how can I make this?

[seanhoots]

Hey @rladrond,
Take a look at the new Group By feature that was announced by bubble about a week ago.

[New Feature] Grouping and Aggregating Data

Hi all, We’ve heard from many of you that you’d like an efficient way of displaying your app’s data in a chart or table. For instance, maybe you’d like to be able to show a graph of new user signups by month, or show a table of total sales by region and account. We now have a tool for supporting this kind of operation. It’s called “:group by”, and you apply it on top of a search or other list of data items in order to group and summarize the list. [group%20by%20screenshot] The basic conce…