Surrey Police Spending Analysis
The data source was a comma delimited set of files containing Surrey Police Spending records for each month between April 2009 and March 2010. Pre-processing these files into a single CSV file simplified the spray, although using ECL this process could have been automated as well. This code demonstrates cross-tabulation reports using TABLE and a number of aggregate functions that are standard in ECL. Enjoy! Attached zip file contains the composite CSV file and ECL code ready for spray and import respectively.