|
Let's continue the analysis.
We're going to compare each sales rep against the average of all sales reps in how well they met their quota.
- Choose Compare Menu
- Select Test Cells Against A Baseline
- Click the Autopopulate Button.
|
 |
|
Continuing in the same dialog...
- Baselines appeared after Autopopulate was pressed. By default, the Average was selected.
- Change the default word "True" to say "Below"
- Change the default word "False" to say "Above"
- Change the default word "Passed Baseline" to say "Exceeded Count"
- Press OK
There would normally be a few cleanup items we would do. For example, the title on the report isn't very useful and also the alerts haven't chosen very colors. We'll leave these items for you to experiment with.
Let's remember that the user interface you're using is Open Source. You have the option of modifying this code to display the data any way you want.
|
test_dlg.png
|
|
 |
| Again, what nextanalytics demo wouldn't be complete without showing you the script you created? Here it is: |
adddata , quotas.csv
;--------------
MathOperation,Multiply,1000,0,row,Actual
AddData , actuals.csv
;--------------
distributecellcollection,byRatio,1,0
Compare,ToRelativeCell,PercentOf,Actual,Row,,,-1,-1,0,0,False,False,1,
ChangeAlertTo,axis,-1,Column,Average,15,True,,-1
autopopulatebaselines
Test,Average from 4,LessThan,0,GreaterThan,2,0, False,False,False,True,Ok,True,Below,True,Exceeded Count,False |
This function showed the number of times a sale rep was below average. If they were below too many times, that fact is flagged in the final column. I could continue this analysis by sorting and filtering to isolate similar behaviours.
|
