Survey Scorecard Average Ratings

[mattweinell]

Hello all,

We are delving into Surveys for the first time and I have a question about the 'Average Rating' on the scorecard. I expected the 'Average Rating' to be an average of all responses to the indicated category but it appears to show some sort of weighted value that I cannot decipher.

The Wiki page isn't much help here either:
Survey scorecard average ratings

I suppose I have 2 questions:

1. What is this rating even displaying?

2. How can I show an average of the category responses?

-Matt

[amanjit]

Average rating is average of normalized values for the metric results for the same metric

The normalized value is calculated in vision of different scales being used by different metrics in the same assessment. For the normalized value is calculation please refer the wiki article here.

Normalized value = (Input Value - Min value defined in metric) / (Max value defined in metric - Min value defined in metric) * current metric weight / (sum of valid metric weight) * scale_factor

This formula cannot be customized.

Example:

Calculate the normalized value for this metric: Please rate the competency of the technician. This metric has the following values:

• Input value = 3
• Minimum value = 1
• Maximum value = 6
• Current metric weight = 10
• Number of responses = 6
  • 4 of type=number
  • 1 of type=yes/no
  • 1 of type=string (invalid data type; value cannot be calculated)
• Valid metric weight of each response = 10
• Scale factor = 10

Normalized value = (3 - 1) / (6 - 1) * 10 / (10 + 10 + 10 + 10 + 10) * 10 = 0.8

[abhishekbasu]

Hi Matthew,

You can create a Report to achieve this. Table to query is 'Task Survey Detail'.

Attaching a screenshot of how I have configured for average responses w.r.t surveys.

Hope this helps.