Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
See the attached sample,
I've calculated the best in class value, my top 1 of Metric Value.
Now I want to get the Code where my Best in class is 4,5 (in the orange box), so I want to get code = 1295.
I want to get this in a text box.
How can I do this?
Thanks in advance,
Sílvia
Try this
=FirstSortedValue({<Code, Active={"1"}>} Code, -Aggr(
if(Avg({<Code=,Metric={"Satisfaction"}>}Value / #RecordCount) <= sum(TOTAL {<Outlier_Metric={"SMC"}, Code>} Outlier),
Round(Avg({<Code=,Metric={"Satisfaction"}>}Value / #RecordCount),0.01)), Code))
Try this
=FirstSortedValue({<Code, Active={"1"}>} Code, -Aggr(
if(Avg({<Code=,Metric={"Satisfaction"}>}Value / #RecordCount) <= sum(TOTAL {<Outlier_Metric={"SMC"}, Code>} Outlier),
Round(Avg({<Code=,Metric={"Satisfaction"}>}Value / #RecordCount),0.01)), Code))
Thanks again Sunny
Regards,
Sílvia