Is it possible to perform aggregate operations in collection types entries view?

I have a “Rating” collection type with numeric field (1 to 5), the user Id and an external item id, what would be the easiest way to display the average rating of all users for each item id ?

This topic has been created from a Discord post (1243547627052597288) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord