What are the numerical ranges for the Knowledge Document ratings?

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

When viewing a Knowledge Document entry using CA Service Desk Manager UI, the "Average rating" shows values such as "Very helpful", "Somewhat helpful", "Not helpful at all".  What are the numerical ranges for these ratings?

For example, on the right-side of the following document, you can see the following message: Document was rated 4 times. Average rating is Somewhat helpful.

 

Environment

CA Service Desk Manager - all versions

Resolution

The numerical values are stored in the AVG_RATING column of the MDB SKELETONS table. 

The numerical value is mapped according to the following rules:

If AVG_RATING is less than or equal to 1 ( <=1 ), then display:
Average rating is Not helpful at all

If AVG_RATING is greater than 1 and less than or equal to 3 ( > 1 and <=3 ) , then display:
Average rating is Somewhat helpful

If AVG_RATING is greater than 3 and less than or equal to 4 ( >3 and <=4 ), then display: 
Average rating is Very helpful

Additional Information

Working with Knowledge Documents