Assessment Metric Results Value Calculation

Kuldeep Kumavat
Mega Guru

Hi,

There is a requirement to configure custom assessments for calculating the T-Shirt size of a Demand.

However, we were not able to figure out the logic/formula used to determine the weighted and the Normalized value of a Metric Result

All our Metrics are of Assessment Type so that the Actual and the Scaled values are same.

The wiki mentions the below about Normalized value (Assessment Results - ServiceNow Wiki😞

Adjusted value that accounts for weights, scale definition, minimum and maximum values, and other factors that impact the metric.

Can anybody help with the logic/formula used to calculated the Weighted and the Normalized Value of a metric.

Regards,

Kuldeep

1 ACCEPTED SOLUTION

jmcquay1
Tera Contributor

We had a ticket opened with SN and received the following calculation for the normalized value in Metric Results.   I hope somebody finds it useful.



(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 defined in metric type


View solution in original post

5 REPLIES 5

Swetans
Tera Contributor

Configure Project Template Solution:

go to project template configuration>new.
configure the tables as picture below.