Ability for registred users to rate other users

Hello

I need to add the ability for my registred users to rate other registered users
In other words, when other users rate each other, it should then show each
users rating like a score of 9.2 or something like that
(N.B. Please see the attached image)

I do not want to do it via star ratings, so I need a numbered rating system
Please help
(N.B. Please see the attached image)

Thank you

You could use the existing rating field to allow them to rate the user you could then use CB Query Field to query the database for the ratings and add all the ratings to together, do the math with SQL functions, then display it. This would allow users to easily rate other users with a star system (easy to understand) and have the average displayed as a digit.

Similar to something I've been trying to work out. I have sort of managed it with the following SQL in a CB Query Field:

SELECT ROUND(AVG (rating),2)
FROM `###_comprofiler_ratingfield_log`
WHERE `rateduserid` = [user_id];

The issue I have is that it is just showing an average for the entire table rather than based on the user_id field - am I doing something wrong in my query?

`###_comprofiler_ratingfield_log`

This isn't correct. Please use the below.

The rest of the query looks fine. The field for the user already has the average however. You'll just need to apply a round to it so it's rounded properly. Example as follows.

You should be able to just do [FIELDNAME] substitution and it'll give you the digital equivalent of their rating.