How to show an average of items?

[hemansu.keeka]

Hi there.

I’ve got the following DB setup.

How do I create a repeating group, which gives me the average score per category, to look like the following?

Many thanks

[mikeloc]

Hi there, @hemansu.keeka… you can use the :group by operator in the repeating group’s data source to group the data by category, and you can create an aggregation in the Group by window to do an average of the Score field. So, the data source would look something like this…

Hope this helps.

Best…
Mike

[hemansu.keeka]

This solved my issue, thanks so much @mikeloc! ! :