Article Rating Reports

[Esqueda]

Hello, I been looking deep for the answer before posting but didn´t found an answer.

Related to the creation of a dashboard to overview the quality of the a knowledge database, i been exploring the OOB Knowledge management dashboard, but it didn´t do tick on all the boxes, so i´m struggling to create a set of reports that fulfills the needs. 

A: a report that is able to give in a percentage, the number of articles of a DB that has a value (rating given by the 5 stars) below a defined threshold. Ex: if the DB has 100 articles, and the ones with a average value lesser than 3,5 are 4, the value should be a 4% of articles with "low quality"

B: A The average score of a DB in a single value, but at the same time doing the averages of all the ratings of each article. i be found that if i use the OOB reports Average rating of the articles by month or  the metric is the average of the ratings done by each article, and from all the ratings it gets the average. this means that if one article its been rated 6 times, each rating counts towards the total average". so if we have 2 articles in a DB, one gets 6 ratings of 5 stars, and the other articles has 1 rating of "0 starts", the average of the DB will not be 2,5, but a higher value.

Any ideas?

[Esqueda]

For the B point I found my self the solution. to get the average, the table to select when making the report must be kb_knowledge to get the average of the ratings of all the published articles.