How to create a Report that shows Knowledge articles in ascending order of average rating?

Aki17
Kilo Guru

‎11-19-2019 01:43 AM

I would like to create a Report that shows Knowledge articles in ascending order of average rating like below.

Could someone let me know how to create such report?find_real_file.png

Best Regards,

Aki

 
Preview file
70 KB
Preview file
68 KB
0 Helpfuls
  • 2,281 Views
3 REPLIES 3

dvp
Mega Sage
Mega Sage

‎11-19-2019 02:57 AM

Create a report on kb_feedback table with filter as Rating IS NOT empty and Rating IS LESS THAN your_desired_value

 

find_real_file.png

Preview file
10 KB
0 Helpfuls

Aki17
Kilo Guru
In response to dvp

‎11-19-2019 04:46 PM

Hi dvp,
Thank you for your reply. Yes, I set the filter in that way and the average rating was presented, but the result has as many rows as ratings. (Please see the image below)

Could you tell me how to put the same KB articles into 1 row?

find_real_file.png

Best Regards,

Aki

Preview file
24 KB
0 Helpfuls

GUPPY
Tera Contributor

‎06-10-2023 02:09 AM

Do your "group by" on "Article" instead of on "rating"

0 Helpfuls