By WalkingTree July 15 2020
The Ext JS Pivot Grid component enables a rapid summarization of large sets of data. It provides a simple way to condense many data points into a single format that makes trends and insights more apparent. Let’s take the example of sales data. A company will have a record of all sales it makes for a given period of time. This will often encompass thousands of rows of data. The Pivot Grid shows how well each salesperson performed, in which cities generate the most revenue and other relevant insights into sales.
Let’s take a look at the top 5 powerful pivot grid features.
Axis and Aggregation – The Ext JS pivot grid relies on 2 factors i.e Axis and Aggregation. Axis manages row and column placements and Aggregation manages group calculations. Many in-built methods are also available such as sum, average, min, and etc.
Filtering – Pivot Grid provides filtering based on a year or value.
Multiple Grand Totals – With Pivot Grid in place, it is convenient to add up multiple grand totals.
Range Grouping – This feature allows in displaying the grid rows aggregated into groups as specified by the grouper.
Drill Down – This feature allows the user to view all records that were aggregated for a specified cell. A double click can open the records viewer.
Read on to know more about Pivot Grid and how to implement it in an application.
INTRODUCTION RIA frameworks are becoming the de facto UI development frameworks in all the major industries today. Earlier,…
There is a favourite quote among social scientists that says, “It takes a village to raise a child”….
It is a well-known fact that we are living in the age of multi-device apps. As part…
As a follow-up to our previous article on Ext JS 6.6 and Open Tooling, this article demonstrates the…
Node.js and NPM have changed the face of front-end development. NPM, an online repository for a plethora of…