What is a Pivot Grid? • A data summarization tool • Enables rapid summarization of large sets of data • Provides a simple way to perform basic analytics
Classic Ext JS Grid: Sales Data • What is John Doe's total order amount? • What are the total order amounts by country? • How did salespeople perform in a specific year?
Pivot Grid Architecture Sencha Pivot Grid Component (Grid panel) Abstract Matrix Local Matrix (all calculations in the browser) Remote Matrix (all calculations remotely on the server) Left Axis Top Axis Results (Aggregation)
Aggregation Methods • Sum • Average • Min • Max • Count • groupSumPercentage • groupCountPercentage • Variance • VarianceP • stdDev • stdDevP Or write your own custom aggregator function.
Stencils for Designers • Symbols used within Design tools (Illustrator, Omnigraffle, etc.) to convey ideas visually • Sencha is bringing framework components closer to the designers, so they can align their designs with the capabilities of framework