How to display multiple ratings average in record list?

I can suggest you what cod you can use but it will be single average. Not multi criteria.

But I need to know average rating of what? Whole section? I mean average of all ratings in whole section?

If I'm not wrong, this can be a good option for ratings in the backend where admins can choose what ratings they want to display in a certain place (all the criteria or just the average), in case of multi criteria, of course.

Yes, you understood correctly. I just need to display the average of all criteria from a record, regardless of calculation method.

Thanks!

$db = JFactory::getDbo();

$query = $db->getQuery(true);

$query->select("AVG(votes_result)");

$query->from("#__js_res_record");

$query->where("section_id = 1");

$query->where("published = 1");

$query->where("parent = 'com_cobalt'");

$db->setQuery($query);

$result = $db->loadResult();

echo '

';

But as I said it is single rating only. To calculate multi-criteria will take more code and could reduce performance.