little help I have 5,5 star ratings A-E I need to calculate the average of them for display in another rating and unsure how to do this.
A = 2 votes value = 7
B = 1 votes value = 3
C = 2 votes value = 7
D = 1 votes value = 3
E = 1 votes value = 1
Printable View
little help I have 5,5 star ratings A-E I need to calculate the average of them for display in another rating and unsure how to do this.
A = 2 votes value = 7
B = 1 votes value = 3
C = 2 votes value = 7
D = 1 votes value = 3
E = 1 votes value = 1
How are they stored?
they are stored in mysql I know how to fetch them just need to know how to calculate the equation
A['total_votes'] (2), A['total_value'] (7)
B ...
C....
D...
Isn't it just total value divided by total votes? Or am I missing something?