LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  Decile performance and rank accordingly

    Employee
    Posted 01-23-2017 16:01

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dglavastorm

    Hi - I have a list of agents and their performance %s which I need to decile, then split the data into the 10 individual groups.

    Does LS have this capability ?

    Example data attached.

    Thanks,
    Dave
    Attachments:
    ls.zip


  • 2.  RE: Decile performance and rank accordingly

    Employee
    Posted 01-23-2017 16:16

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: AdamParker

    If I understand what you are asking, yes we can do that.

    Here is an example filter that splits it out:

    node:Split_Data_into_Deciles
    bretype:core::Filter
    editor:Label=Split Data into Deciles
    editor:sortkey=58868d0f5f9b3f8f
    input:@40fd2c74167f1ca2/=
    output:@40fd2c7420761db6/=
    output:58868d251d9e1261/out2=
    output:58868d262d353f8f/out3=
    output:58868d27356d0cbf/out4=
    output:58868d285cf726f5/out5=
    output:58868d2921754f39/out6=
    output:58868d2a3a17792f/out7=
    output:58868d2b683b53cb/out8=
    output:58868d2b6dec3446/out9=
    output:58868d2d61725df3/out10=
    prop:Output Fields=<<EOX
    
    emit *
    emit _rank as "Decile"
    
    output 1 {where _rank == 1}
    output 2 {where _rank == 2}
    output 3 {where _rank == 3}
    output 4 {where _rank == 4}
    output 5 {where _rank == 5}
    output 6 {where _rank == 6}
    output 7 {where _rank == 7}
    output 8 {where _rank == 8}
    output 9 {where _rank == 9}
    output 10 {where _rank == 10}
    
    EOX
    prop:Script=<<EOX
    _numToRank = 'Results'
    
    _rank =
    	if _numToRank < 10.0
    	then 1
    	else
    	{
    		if _numToRank < 20.0
    		then 2
    		else
    		{
    			if _numToRank < 30.0
    			then 3
    			else
    			{
    				if _numToRank < 40.0
    				then 4
    				else
    				{
    					if _numToRank < 50.0
    					then 5
    					else
    					{
    						if _numToRank < 60.0
    						then 6
    						else
    						{
    							if _numToRank < 70.0
    							then 7
    							else
    							{
    								if _numToRank < 80.0
    								then 8
    								else
    								{
    									if _numToRank < 90.0
    									then 9
    									else 10
    								}
    							}
    						}
    					}
    				}
    			}
    		}
    	}
    
    {{^Output Fields^}}
    EOX
    editor:XY=210,130
    editor:propdef=Output Fields|brainscript|Output||None
    end:Split_Data_into_Deciles
    Edit: The above filter assumes the 'Result' field is a double type.


  • 3.  RE: Decile performance and rank accordingly

    Employee
    Posted 01-23-2017 16:33

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: dglavastorm

    Thanks Adam, but apologies as I wasn't clear. I need to the results to be deciled first, so the ranking limits will change with each dataset.
    Another example dataset attached with the decile limits as per formula from excel.

    Cheers,
    Dave
    Attachments:
    ls.zip


  • 4.  RE: Decile performance and rank accordingly

    Employee
    Posted 01-23-2017 18:21

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    Try this graph. I'm not sure I have the computation fully correct, but it shows you how many of the manipulations can be performed.
    Compute Deciles.brg