I teach on a Moodle 3.1 site and I like the 'single rating' scale which we have here on moodle.org forums as well. I've set up a scale on my site with one value - 'useful' - and I've used this scale in some forums.
I'd like to know if there's a way to generate a report that shows this in the context of a specific forum within a course:
||number of forum posts rated as 'useful' at least once|| total number of 'useful' ratings received
Is there perhaps an SQL query I can run, and could anyone help me write this query?