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?
+28Hmm, 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?
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.