Top 5 Ext JS Pivot Grid features
Blog|by Leanne Bevan|10 September 2020
Ext JS is Sencha’s comprehensive JavaScript framework. The Pivot Grid condenses various data points into a format making it easy for users to understand data insights and trends.
A classic example is sales data. A company will often have a record of all sales it makes for a given period which can encompass thousands of rows of data. The Pivot Grid allows users to see how well each salesperson performed, which cities generate the most revenue, how products perform between cities, etc.
Let’s take a look at the top 5 powerful Ext JS Pivot Grid features as curated by Sencha’s Kirti Joshi.
1 – Axis and Aggregation
The Pivot Grid extends the native grid panel using Axis and Aggregation.
- Axis: allows you to determine row and column placement
- Aggregation: manages the grouping calculations
There are many in-built methods available such as sum, average and minimum, for example. However, it is possible to define a custom method to aggregate data.
These features make it easier to view data as well as easily group data to make analysis much easier for the user.
2 – Filtering
Another great feature is the ability to filter by label or value, enabling users to add plenty of data to their application for comprehensive tables and reports.
3 – Multiple grand totals
Some reports and tables are more complex where multiple grand totals are required for analysis and reference. For example, a shop might want a grand total of overall orders, as well as grand totals of specific product types, or perhaps different regions. This can help users to understand and track sales, and where changes might need to be made.
4 – Range grouping
It’s possible to group ranges – see for yourself in the demo environment, Sencha Fiddle.
5 – Drill down
And finally, users can drill down to get even more information about specific aspects of data to make more informed decisions and to have a better understanding of the finer details.
If you want to create apps with comprehensive pivot grids for end users to utilise for better understanding of data, then consider using Ext JS.
If you’re already an Ext JS user, let us know your go-to features and why they are your favourites, using the contact details below.
Find out more
If you would like to give Sencha Ext JS and the Pivot Grid a go yourself, please contact our team who can advise you on free trials, key documentation and examples, as well as provide licensing and updates on the latest discounts available. Call +44 (0) 1364 655123 or email info@greymatter.com. Grey Matter is a Sencha Authorised Reseller.
Contact Grey Matter
If you have any questions or want some extra information, complete the form below and one of the team will be in touch ASAP. If you have a specific use case, please let us know and we'll help you find the right solution faster.
By submitting this form you are agreeing to our Privacy Policy and Website Terms of Use.
Leanne Bevan
Related News
Women in Tech: A New Era | Roundtable
Fri 21 June 2024 5:00 pm - 11:30 pm BST
Get ready to shake it off (and network like nobody’s watching) because we’re hosting an exciting exclusive Women in Tech event with ESET that you won’t want to miss out on. Join us and share feedback, experiences and insights with...
Cyber Security Day
Tue 16 July 2024 10:00 am - 3:00 pm BST
Learn How to Protect Your Business Against Cyber Threats and Improve Your Security Posture Join Grey Matter and ESET for a free event on the picturesque Bournemouth coastline where you will learn about the latest cyber security trends, network and...
RAD Studio 12.1 Now Available
Embarcadero Technologies announces the General Availability of RAD Studio 12.1, including Delphi 12.1 and C++Builder 12.1 RAD Studio, Delphi and C++Builder 12.1 primarily focus on improving the quality of the new features in RAD Studio 12, addressing regressions, and focusing...
New changes to Microsoft 365, Office 365, and Microsoft Teams licensing
As of 1 April, 2024, Microsoft has updated its licensing structure for Microsoft 365, Office 365 and Microsoft Teams. It has introduced Microsoft 365 and Office 365 suites that don’t include Teams, in addition to a new standalone Teams offering. ...