Need a special offer?Find out if your project fits.
+

Examples

We often use JSFiddle.net to provide live examples of our pivot table component. JSFiddle is a free development environment that allows editing and execution of HTML, JavaScript and CSS. With the help of this tool, we have added more than 400 fiddles demonstrating our functionality: from API calls to integration with charting libraries. All examples are divided into categories. Please have a look at the categories menu on the left side. If you are not sure which category is needed just scroll down and look through the titles.

Check out more than 400 samples

Embedding Flexmonster

Flexmonster is embedded via new Flexmonster() API call. In this section, you can find various examples showing how to embed pivot table. Also, here we added integrations with d3.js, ECharts and Kendo UI Splitter widget.

    Data source

    Our component supports a variety of data sources: CSV, JSON, SQL databases and OLAP cubes. This section demonstrates the connection to each data source either by defining it in the report or using API calls.

      Configuring the slice

      Define which data is shown in your reports: add rows, columns, measures, and report filters. Learn how to configure sorting and different types of filtering, expand values, and many more in this section.

        Conditional formatting

        Flexmonster pivot table allows highlighting cells depending on their values. Conditional formatting is available both via API or via the user interface. This section shows how to configure conditional rules in our component.

          Number formatting

          Numeric values can easily be formatted in Flexmonster. This section shows how to set currency symbol, precision, thousand and decimal separators.

            Setting options

            With the help of options, it is possible to configure which functionality is available for the end users as well as the appearance of Flexmonster Pivot Table.

              Calculated measures

              Our pivot table allows creating calculated values which can be saved within the report and later be opened again. Calculated values can be added via UI, whereas this section shows how they are defined in the code.

                Configuring the report

                This section demonstrates various ways to define a report in Flexmonster. Each report contains information about the data and how it will be visualized.

                  Customizing the grid

                  Flexmonster provides customizeCell function which can modify each cell in the table during rendering. Below are the most common use cases of grid customization.

                    Customizing the Toolbar

                    Our pivot table comes with the Toolbar that provides access to the main functionality. This section shows different ways to modify the current Toolbar by adding or removing tabs.

                      Demos

                      All demos from our Demos section are gathered below. Find different data sources, color schemes and views.

                        CSS themes

                        Flexmonster comes with sixteen predefined themes. Choose between available color schemes and change the style of the component.

                          Custom CSS

                          Configure the look and feel of Flexmonster Pivot Table by adding custom CSS styles. Everything can be customized: from font sizes to chart colors.

                            Flexmonster Pivot Charts

                            This section lists examples with the component's built-in charts - Flexmonster Pivot Charts.

                              Highcharts

                              See the data from a new perspective by integrating Flexmonster with Highcharts library. Find the needed Highcharts type in the list below.

                                amCharts

                                Extend the component's visualization functionality by integrating Flexmonster with amCharts library. Find the needed amCharts type in the list below.

                                amCharts 5

                                  amCharts 4

                                    FusionCharts

                                    Get even more from data visualization by integrating with FusionCharts. Find the needed FusionCharts type in the list below.

                                      Google Charts

                                      Enhance web reporting experience by integrating with Google Charts. Find the needed Google Charts type in the list below.

                                        Events

                                        Flexmonster offers a variety of different events. This section shows how they all work and also some interesting use cases.

                                          Export and print

                                          Export our pivot table to Excel, PDF, HTML, image, CSV, or simply print it. Check out the most popular ways to use export in the section below.

                                            GlobalObject

                                            With the GlobalObject, Flexmonster can save certain configurations common for all reports. This section demonstrates how the GlobalObject might be used.

                                              Other

                                              Here are gathered some other interesting use cases.