Overview of Webix Pivot Table and Pivot Chart Widgets

Webix UI library contains high-performance widgets and controls that greatly facilitate work with large volumes of data. But for solving more complicated tasks connected with data aggregation and visualization, you can use Webix complex widgets. They are single-page applications that developers can integrate into their business solutions. In this way, a lot of time can be saved on designing and developing web apps. Complex widgets are usually created in close cooperation with the Webix community.

Pivot Table and Pivot Chart are compelling examples of complex widgets that allow organizing big amounts of data and creating visual reports. Although these components have many features in common, there are several differences between them.

Pivot

Webix Pivot represents a JavaScript table with extended filtering capabilities. It allows making efficient visual reports over big and complex datasets. Pivot helps sort, count, total, filter, compare, and give the average of data within a datatable. You can also change the analysis pattern in an instant. Pivot UI widget serves for data summarization and analysis. It can be easily implemented into an application or HTML page.

You can customize Pivot design for your application. The widget allows loading data from external sources or local drive and exporting data to PDF, Excel, CSV formats.

You can change the organization of data within Pivot Table just by dragging and dropping fields.

By the way, Webix includes another powerful component that facilitates work with large volumes of data — JavaScript SpreadSheet widget.

Pivot chart

Webix Pivot Chart is another JS tool designed for graphical representation of data items. There are a lot of configuration options that enable users to understand, research, and analyze huge volumes of data at high speed. Pivot chart offers even more capabilities for summarizing complex datasets.

Webix Pivot Chart allows creating charts that have all the key Pivot Table functions. Just like JavaScript Charts widget, it shows data categories, series, and chart axes. It also provides interactive filtering controls that help quickly analyze datasets.

Pivot Chart includes various types of charts such as line, area, bar, spline, donut, pie, 3d pie, scatter, and radar.

You can easily customize different elements of the widget (titles, legend, chart location) according to your business needs.

Pivot Chart allows loading data in JSON, XML, CSV, and JSArray formats from the local drive or external sources.

You can change data representation in the chart report simply by dragging and dropping its fields. So there is no need to perform excessive coding!

With Webix Pivot Chart you can:

• extract and show the key information from complex data sets.
• export data to Excel, PDF, CSV, or PNG.
• customize chart settings, filters, and the configuration window.
• create grouping functions for data aggregation
• adjust text labels and numbers to the rules of different countries.

Bottom line

Webix JavaScript Pivot Table and Pivot Chart widgets facilitate and systematize work with large and complex datasets. Both of them have their own sets of functions and capabilities that are indispensable for processing big amounts of data and creating reports.