Skip to content

flexmonster/js-pivot-table

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

31 Commits
 
 
 
 

Repository files navigation

Flexmonster Pivot Table & Charts

Flexmonster Pivot Table & Charts Website: www.flexmonster.com

What is JS Pivot Table by Flexmonster?

Flexmonster Pivot Table & Charts is a component for interactive pivot reports that can be inserted to a web page or a web application. It’s a powerful JavaScript tool to visualize your business data.

With Flexmonster, you have no limitation on server-side technology, no matter whether your website runs on .NET, Java, PHP, Ruby, etc.

Why use Flexmonster Pivot Table & Charts?

Easy to integrate

Flexmonster Pivot Table & Charts can be natively used with JavaScript or TypeScript. It perfectly integrates with Angular, React, Vue, and many other frameworks - see our Integration with frameworks section.

Supports the most common data sources

High speed in visualizing your data

Our solution allows you to work extremely fast with really large data volumes (huge OLAP cubes, datasets from SQL databases, or files up to 100MB). The maximum data size is limited only by end-user browsers and the capacity of their devices. The table renders multiple millions of cells immediately. If the user’s browser can handle it, we’ll display it.

To gain even better performance while working with JSON, CSV, and datasets from SQL databases, use Flexmonster Data Server - a special server developed by Flexmonster. It fetches data from a data source, processes, aggregates it, and then passes to Flexmonster Pivot in a ready-to-show format. The Data Server significantly reduces data loading time and allows you to analyze large datasets (CSV and JSON files more than 1 GB).

Working with OLAP cubes, a browser component can communicate with the server via XMLA protocol, or you can use Flexmonster Accelerator for OLAP cubes. It’s a special server-side proxy that helps you increase data loading speed from the server to the user’s browser tenfold.

Smart features to analyze and manage your data

Flexmonster Pivot Table & Charts provides Excel-like features that give users the interface they have always used. The users can easily and quickly analyze data and produce a report using different options such as:

  • Filtering
  • Sorting
  • Grouping fields in rows and columns
  • Drill-down
  • Drill-through
  • Calculated fields
  • Number formatting
  • Aggregations
  • Conditional formatting

Learn more about report configuration.

Customizable & flexible

Extensive API

The component has a convenient full-functional JavaScript API to embed the component into web applications. Being a developer, you can:

  • Define what features you want to enable/disable
  • Build your own scenarios around the component

API Reference

Localizing component

Localize Flexmonster Pivot Table & Charts easily using the prepared JSON files:

You can also create a custom localization file. Our guide on localization gives more details about localizing Flexmonster.

Compose report layout

Select which dimensions & values to show. Users can easily change a report layout visually and examine the data from a different perspective. It allows you to stop guessing all possible report scenarios your end-users might require. The user will be able to tune it to their needs on the fly.

Save & load reports

Users can create reports, save them to their local drive or the server, and load previously saved reports with the same configurations.

Export & print

All table views (compact/classic/flat) and charts can be exported or printed. Users can export the reports into a variety of formats:

  • Microsoft Excel 7
  • PDF
  • HTML page
  • CSV (comma-separated text format)
  • Image (PNG)

You can control where to save the export data:

  • to the local computer
  • to the server (to remote file storage or database)

Resources

You can also get support from our Tech team by raising a ticket via Flexmonster Help Center.

How to get Flexmonster Pivot?

Download free trial