Help

Calculating Average Rating

Topic Labels: Data Formulas
987 1
cancel
Showing results for 
Search instead for 
Did you mean: 
v_c_
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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?