Home
Filter and combine then compare (advanced example)
This example shows how easy it is to compare top performers to the entire group using simple filtering, combine and compare operations.

Load sample data 

Script
  1. adddata , actuals.csv

First we load the sample data.  
 

Keep only those 90% above average 

Script (continued)
  1. FilterByValue,KeepByVal,GreaterThan,Row,-1,12/06,True,.9,0,False,Average

We've filtered the data to keep only rows greater than 90% above average in 12/06. Take note that the number of rows could fluctuate each time the data is refreshed so, even if you could do this in a spreadsheet, you'd run into problems with fluctuating range sizes. We will use this data to demonstrate how easy it is to follow such an operation with another. In this example, we will now calculate the average value for this top performing group.   
 

Calculate the average 

Script (continued)
  1. Combine,Row,Average,SelectedDefaultToAll,Remove,Keep,Average of Top Performers,False

This set of numbers could now be used as a a basis for comparison operations.

Name Region Position 01/06 02/06 03/06 04/06 05/06 06/06 07/06 08/06 09/06 10/06 11/06 12/06
Average of Top Performers     48,978 77,761 103,017 44,670 96,330 127,639 61,904 98,348 130,830 74,922 93,543 218,952

 

Compare top performer average to overall average 

Script (continued)
  1. Compare,ToAxis,PercentOf,Average,Column,,,-1,-1,0,0,False,False,0,  

This shows the percent of the average top performer as compared to the overall average in each month. We provide this example as demonstration of the ease and power of being able to derive subsets, perform computations, and compare the results in one short (12 lines) analytical script.

Name Region Position 01/06 02/06 03/06 04/06 05/06 06/06 07/06 08/06 09/06 10/06 11/06 12/06
Average of Top Performers     134 122 109 116 123 108 139 117 106 127 123 150

 

 

 
< Prev   Next >