Overview of Webix Pivot Table and Pivot Chart Widgets

Webix
Webix
Jul 17 · 3 min read

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.

Webix

Written by

Webix

#JavaScript UI library for #cross-platform #web app development with 99+ #UI widgets and fully-featured #CSS / #HTML5 JavaScript controls. www.webix.com

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade