Rankx to measure performance

[Anonymous]

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 )
)
)))

[v-jayw-msft · Accepted 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.

[CheenuSing]

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