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.
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.
- JSON
- CSV
- SQL databases (MS SQL, MySQL, and others)
- Microsoft Analysis Services OLAP cubes
- Custom data source API
- Elasticsearch
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.
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.
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
Localize Flexmonster Pivot Table & Charts easily using the prepared JSON files:
- English (default)
- Spanish
- French
- Chinese
- Hungarian
- Italian
- Portuguese
- Ukrainian
- German
- Dutch
- Turkish
You can also create a custom localization file. Our guide on localization gives more details about localizing Flexmonster.
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.
Users can create reports, save them to their local drive or the server, and load previously saved reports with the same configurations.
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
- 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)
You can also get support from our Tech team by raising a ticket via Flexmonster Help Center.