Calculate average in interface

[toutautrechose]

Hey I'm quite new but couldn't find an answer : I'm looking to show the average of a column in the interface. To be specific, I have a set of data from one table and I'm selecting certain data from another table, and I want to calculate the average of specific values from this other table in the interface. (It's for managing events, so I have a list of events in one table and another table with all our members and for example their age, and I select the participants in the specific activity and want to be able to calculate the average for example of the age of the participants from the list of members).

Hope it's kinda clear, thanks!!

[ladla_karan]

It's a bit unclear if the average is required on the complete column or linked records in the events table.

Kindly attach the screenshot of the tables to help us help you better.

[TheTimeSavingCo · Accepted solution]

What if you created a rollup field and displayed that in the Interface instead?

Link to base

[toutautrechose]

Thats perfect thank you very much!