- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 19, 2023 11:30 AM
Hi, I have a database for a marketplace and I want to calculate average rating for each service. I have a table called Services, which lists each service, and there is a column called Reviews, which links to a table called Reviews with a primary column that has the formula for listing the number of stars numerically (rating). How would I get the average rating for each Service and have that as a column in Services?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 19, 2023 08:19 PM
Hmm, so all the "Review" records are already linked to the "Service" records appropriately?
If so, try creating a rollup field in "Services" that will rollup the primary column of "Reviews" with the formula "AVERAGE(values)"
If that doesn't work, could you provide some screenshots of your tables and the relevant fields?
