Loading...
Loading...
Normalized value for Metric Result of Assessment Metric (survey question) with method "Default answer from script" is always doubled when calculating the Rating and Normalized value of Assessment Category Result. Steps to Reproduce 1. Create a new Assessment Metric Type record in the table asmt_metric_type by clicking "New". Fill out the mandatory fields as follows and submit/save: Name = any text Scale factor = 1 Table = Incident [incident] Condition: Number is INC0000002 2. Go to the Metric Categories related list on the Assessment Metric Type record and click "New" to create a assessment category. Fill out the mandatory fields as follows and submit/save: Name = any text Filter: Active is true 3. Go to the Assessment Metrics related list on the assessment category record and click "New" to create 1st Assessment Metric record under this assessment category. Fill out the mandatory fields as follows and submit/save: Method = "Default answer from script" General tab: Name = Question 1 Question = Question 1 Ask question = Only if script provides no default answer Field Type tab: Data type = Choice Dependent plugin = Core Script: actual_result = 1; scaled_result = 1; 4. Go to the Assessment Metric Definitions related list on Assessment Metric record "Question 1" and click "New" to create the following 3 Assessment Metric Definitions for Assessment Metric record "Question 1": - Display = Answer 1, Value = 0, Normalization Input = 0 - Display = Answer 2, Value = 1, Normalization Input = 1 - Display = Answer 3, Value = 2, Normalization Input = 2 5. Go to the Assessment Metrics related list on the assessment category record and click "New" again to create 2nd Assessment Metric record under this assessment category. Fill out the mandatory fields as follows and submit/save: Method = "Assessment" General tab: Name = Question 2 Question = Question 2 Field Type tab: Data type = Choice 6. Go to the Assessment Metric Definitions related list on Assessment Metric record "Question 2" and click "New" to create the following 3 Assessment Metric Definitions for Assessment Metric record "Question 2": - Display = Answer 1, Value = 0, Normalization Input = 0 - Display = Answer 2, Value = 1, Normalization Input = 1 - Display = Answer 3, Value = 2, Normalization Input = 2 7. Go back to the Assessment Metric Type record and Click "Publish". 8. Click "Generate Assessable Records" related link on the Assessment Metric Type record and notice that the Assessable Record INC0000002 would be created on the Assessable Records related list on the Assessment Metric Type record. 9. Click "Assign Assessment" on the Assessment Metric Type record. Select "System Administrator" as the assessor and click "OK". A assessment instance for this Assessment Metric Type would be created and assigned to Admin user. 10. Go to the table asmt_assessment_instance and open the assessment instance record. Click "Take assessment" to open the survey instance. Select "Answer 2" for the Question 2 and click "Submit". 11. Go to the table asmt_metric_result and sort the records to view the latest records in the table. Notice that there should be 2 Metric Result records for both "Question 1" and "Question 2". They both have Normalized value as 0.25. 12. Go to the table asmt_category_result and open the latest Assessment Category Result record. Notice that both Rating and Normalized value are 0.75. Expected behavior: According to the documentation https://docs.servicenow.com/bundle/quebec-servicenow-platform/page/administer/assessments/task/t_ViewACategoryResult.html, both Rating and Normalized value of Assessment Category Result should be 0.5. Rating = (0.25+0.25) / 1 = 0.5 Normalized value = 0.5 * (10/10) = 0.5 Actual behavior: Both Rating and Normalized value of Assessment Category Result are 0.75. It seems Normalized value for Metric Result of Assessment Metric "Question 1" with method "Default answer from script" is doubled or calculated twice. Rating = (0.25+0.25+0.25) / 1 = 0.75 Normalized value = 0.75 * (10/10) = 0.75
There is no any workaround available for this problem because the logic for the calculation is implemented in Java source code layer so that source code change will have to be made in order to fix the problem. If possible, please try to use the method "Assessment" instead of the method "Default answer from script" for any Assessment Metric in order to avoid this problem and get the correct result of the calculation.
PRB1510911
Click on a version to see all relevant bugs
ServiceNow Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.