Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need help in calculating the Overall Close Score based on the Category Score calculations.
Looking to do it in a TEXT OBJECT since it will be just a single value.
Table expressions:
SLA Category(Critical-High-Medium-Low)
=count(DISTINCT {<[SLA Impact]={"Critical"}>}ID)
=count(DISTINCT {<[SLA Impact]={"High"}>}ID)
=count(DISTINCT {<[SLA Impact]={"Medium"}>}ID)
=count(DISTINCT {<[SLA Impact]={"Low"}>}ID)
Points Deducted
=(Critical *(-10)) + (High *(-5)) + (Medium *(-3))
Category Score
=(1) + ([Points Deducted]/(100))
Need to calculate an Overall Close Score
Category Scores/5
ie: 97+94+100+100+97= 488
488/5 = 97.6%
May be this in the text box object:
Avg(Aggr(
(1) + ((count(DISTINCT {<[SLA Impact]={"Critical"}>}ID)*(-10)) + (count(DISTINCT {<[SLA Impact]={"High"}>}ID)*(-5)) + (count(DISTINCT {<[SLA Impact]={"Medium"}>}ID)*(-3))/(100)), [SLA Category]))
Sunny T,
I tried this in a Text Object and the result was -2.3633333, which I believe averaged out the (-negative) amount calculated based on the Count and not the average of all 5 calculated Category Scores.
Dan
Try this:
Avg(Aggr(
((1) + ((count(DISTINCT {<[SLA Impact]={"Critical"}>}ID)*(-10)) + (count(DISTINCT {<[SLA Impact]={"High"}>}ID)*(-5)) + (count(DISTINCT {<[SLA Impact]={"Medium"}>}ID)*(-3))/(100))), [SLA Category]))