Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
So I am trying to use Rankx to measure performance of agents. However each KPI has it's own goal.
Quallity | <= .90 |
AHT | >= 10 |
Wrap | >= 2 |
CSAT | <= .80 |
Example
Current formula
Ranking =
RANKX (
ALL ( 'Roster' ),
RANKX ( ALL ( 'Roster'), [QA], ,ASC )
+ DIVIDE (
RANKX ( ALL ( 'Roster'), [AHT (Call)] , ,DESC ),
( COUNTROWS ( ALL ( 'Roster' ) ) + 1 )
+ DIVIDE (
RANKX ( ALL ( 'Roster' ), [Avg. Wrap] , ,DESC ),
( COUNTROWS ( ALL ( 'Roster' ) ) + 2 )
+ DIVIDE (
RANKX ( ALL ( 'Roster'), [CSAT offered] , ,ASC ),
( COUNTROWS ( ALL ( 'Roster' ) ) + 3 )
)
)))
Solved! Go to Solution.
Hi @Anonymous ,
I think your formula is fine and you just need to increase the proportion of each row like below.
rankvalue =
var a = RANKX(ALL('Table'),[A1],,DESC,Dense)*100000
var b = RANKX(ALL('Table'),[B1],,DESC,Dense)*1000
var c = RANKX(ALL('Table'),[C1],,DESC,Dense)*10
var d = RANKX(ALL('Table'),[D1],,DESC,Dense)
return
a+b+c+d
And if your proportion for each row is low the result would be effected.
rankvalue =
var a = RANKX(ALL('Table'),[A1],,DESC,Dense)*4
var b = RANKX(ALL('Table'),[B1],,DESC,Dense)*3
var c = RANKX(ALL('Table'),[C1],,DESC,Dense)*2
var d = RANKX(ALL('Table'),[D1],,DESC,Dense)
return
a+b+c+d
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
I think your formula is fine and you just need to increase the proportion of each row like below.
rankvalue =
var a = RANKX(ALL('Table'),[A1],,DESC,Dense)*100000
var b = RANKX(ALL('Table'),[B1],,DESC,Dense)*1000
var c = RANKX(ALL('Table'),[C1],,DESC,Dense)*10
var d = RANKX(ALL('Table'),[D1],,DESC,Dense)
return
a+b+c+d
And if your proportion for each row is low the result would be effected.
rankvalue =
var a = RANKX(ALL('Table'),[A1],,DESC,Dense)*4
var b = RANKX(ALL('Table'),[B1],,DESC,Dense)*3
var c = RANKX(ALL('Table'),[C1],,DESC,Dense)*2
var d = RANKX(ALL('Table'),[D1],,DESC,Dense)
return
a+b+c+d
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
When you are trying to get Rank based on 4 different criteria. I would recommend a weightage to be given to each criteria. Then using the achievement in each criteria arrive at the weightage for the criteria. Sum up the weightage of criteria. Then rank based on the sum weihtage.
Cheers
CheenuSing
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |