Showing Average of 3 different rating fields

Hey,

Is it possible to show the average of three different rating fields on a profile as a stars rating field (that users cannot rate onto)?

You want the average of the 3 rating fields combined? There's no functionality for that, but you maybe able to do it with CB Query Field by querying for the 3 values dividing by 3 then using IF substitutions to determine how many stars to display.

Cool will look into it. I had already thought about the query field but didnt know you could do IF substitutions to determine how many stars. Thanks

The below should work with the query field for example to do IF substitution star output.

[cb:if FIELD_NAME>="1"]<span class="fa fa-star"></span>[/cb:if]
[cb:if FIELD_NAME>="2"]<span class="fa fa-star"></span>[/cb:if]
[cb:if FIELD_NAME>="3"]<span class="fa fa-star"></span>[/cb:if]
[cb:if FIELD_NAME>="4"]<span class="fa fa-star"></span>[/cb:if]
[cb:if FIELD_NAME<"4"]<span class="fa fa-star-o"></span>[/cb:if]
[cb:if FIELD_NAME<"3"]<span class="fa fa-star-o"></span>[/cb:if]
[cb:if FIELD_NAME<"2"]<span class="fa fa-star-o"></span>[/cb:if]
[cb:if FIELD_NAME<"1"]<span class="fa fa-star-o"></span>[/cb:if]

Believe that should work for displaying up to 4 stars with field values 1-4. If the field is less than the next start it should show an empty star (can just exclude that usage if you wanted).