Flexmonster 3.0 Roadmap

Planned features and key release milestones

Welcome to the Flexmonster Pivot 3.0 roadmap. Here, you will find a list of features and key development milestones. The features are categorized and arranged in the order of their planned implementation. We update the roadmap regularly. Status indicators next to the features show what has been completed, what is currently under development, and what is planned. The new badge highlights the features that are introduced in Flexmonster 3.0 and are not available in Flexmonster 2.9.

1. done New architecture new

  1. Every aspect of the architecture was thoughtfully reconsidered and reimagined for the front end and back end of Flexmonster Pivot
  2. The new architecture optimizes data storage, querying, and transfer, minimizing response times and ensuring a smooth UI
  3. The latest development standards were adopted, and no legacy code remains

2. done Grid serves as the foundation for displaying pivot tables and flat tables

  1. Virtualized rendering and scrolling are optimized for handling large datasets
  2. Improved UI/UX
  3. Cell selection has an improved experience with the following features:
    1. Select an area by dragging
    2. Select an area by pressing the “Shift” key
    3. Select different cells using the “Ctrl” or “Command” key
    4. Select an entire row or column by clicking on the sheet header
    5. Select all cells by pressing “Ctrl+A” or “Command+A”
    6. Scroll through the grid with the keyboard while moving a selected cell
    7. Scroll through the grid by selecting an area new
  4. Copying the content of selected cells by pressing “Ctrl+C” or “Command+С”
  5. Resizing columns and rows
  6. Showing or hiding sheet headers through a configurable option
  7. Support for multiline text in cells

3. in progress Flat table control

  1. done Creating a flat table using either a tag new or code
  2. done Improved UI/UX
  3. done Sorting rows based on one of the columns
  4. later Sorting rows based on several columns using the “Ctrl” or “Command” key
  5. in progress A total row that aggregates data for each column
    1. done Aggregation functions:
      1. For numbers: sum, average, count, distinct count, median, product, min, max
      2. For strings: count, distinct count, first new, last new
      3. For booleans new: count, count of true, count of false, OR, AND
      4. For dates: count, distinct count, min, max
    2. in progress Choosing an aggregation function for each column using the field list
    3. in progress Turning off aggregation for any column completely using the field list, so its total will not appear in the total row
    4. in progress An option to position the total row either at the top or the bottom of the table
  6. later Rearranging columns in the grid by dragging them

4. in progress Flat field list control manages field selection for a flat table

  1. done Creating a flat field list control using either a tag new or code
  2. done Improved UI/UX
  3. done Complete control over the positioning of the field list on the web page new
  4. done A list of all available fields, complete with a search box
  5. done Selecting fields to include in the table
  6. done Reordering selected fields
  7. later Renaming fields from the UI
  8. in progress Choosing an aggregation function for each field, which will be used in the total row of the flat table
  9. in progress Turning off aggregation for any field completely, so its total will not appear in the total row of the flat table

5. in progress Pivot table basic control

  1. done Creating a pivot table using either a tag new or code
  2. done Improved UI/UX
  3. done Adding as many fields as needed in the rows, columns, and values
  4. done Values can be at any position in the rows or columns, or may even be absent new
  5. done Aggregation functions for values:
    1. For numbers: sum, average, count, distinct count, median, product, min, max
    2. For strings: count, distinct count, first new, last new
    3. For booleans new: count, count of true, count of false, OR, AND
    4. For dates: count, distinct count, min, max
  6. done Choosing an aggregation function for each value using the field list
  7. done Expanding and collapsing nodes for rows and columns when multiple fields are selected
  8. later Filtering data is planned for later — see Basic filter control and Advanced filter control below

6. in progress Pivot field list control manages field selection for a pivot table

  1. done Creating a pivot field list control using either a tag new or code
  2. done Improved UI/UX
  3. done The field list layout adapts according to the available space new
  4. done Complete control over the positioning of the field list on the web page new
  5. done A list of all available fields, complete with a search box
  6. done Selecting fields to include in the pivot table, determining which fields go into rows, columns, and values
  7. in progress Selecting fields to include in the report filters box
  8. done Reordering fields within the rows, columns, and values
  9. later Renaming fields from the UI
  10. done Choosing an aggregation function for each field selected as a value

7. done Flexmonster Pivot server

  1. Optimized data import — the initial data processing requires less memory and CPU resources
  2. Optimized memory usage — Flexmonster Pivot server side uses less memory to perform the same tasks as FDS 2.9
  3. Support for CSV and JSON formats — data can be imported in both CSV and JSON formats (more information about processing these formats can be found in the designated sections JSON support and CSV support below)

8. done Increased max data limit

  1. The maximum data limit for Flexmonster Pivot has increased from about 1GB to several tens of gigabytes

9. done Socket connection new

  1. The socket connection between the client and server sides of Flexmonster Pivot

10. done Data exchange protocol new

  1. The data exchange protocol between the client and server sides of Flexmonster Pivot enables instant data visualization on the client side

11. done JSON support

  1. Supported JSON formats:
    1. Array of objects
    2. Array of arrays
  2. Supported data types: number, string, bool new, date (ISO), datetime (ISO string or timestamp in milliseconds)
  3. Improved autodetection of data types during parsing
  4. Support for metadata in the first object of the JSON array to:
    1. Explicitly define the data type for each field
    2. Specify a caption for each field
  5. Support for a data schema that allows the definition of how fields from the data are handled and transformed during parsing:
    1. Explicitly define the data type for each field
    2. Specify a caption for each field
    3. Skip a field during parsing
  6. An ability to load JSON data directly to the client side of Flexmonster Pivot:
    1. From a remote JSON file or data generated by a server-side script
    2. From a JSON file on a computer
    3. Using inline JSON data

12. done CSV support

  1. Supported data types: number, string, bool new, date (ISO), datetime (ISO string or timestamp in milliseconds)
  2. Improved autodetection of data types during parsing
  3. Support for embedded metadata within CSV data new:
    1. Specify a separator for data using sep
    2. Specify a decimal separator for numbers using #decimalSeparator
    3. Explicitly define the data type for each field using #datatype
    4. Specify a caption for each field using #caption
  4. Support for a data schema that allows the definition of how fields from the data are handled and transformed during parsing:
    1. Explicitly define the data type for each field
    2. Specify a caption for each field
    3. Skip a field during parsing
  5. An ability to load CSV data directly to the client side of Flexmonster Pivot:
    1. From a remote CSV file or data generated by a server-side script
    2. From a CSV file on a computer

Prerelease demo July 2, 2025

We launched https://prerelease.flexmonster.com/, featuring two demos of the upcoming Flexmonster 3.0: a pivot table and a flat table.

13. Flexmonster Pivot admin panel — GUI for the Flexmonster Pivot server

  1. in progress Improved UI/UX of the cross-platform desktop application
  2. Management of data sources
    1. CSV/JSON
    2. Management of data schemas
    3. Support for more data sources is planned for later — see SQL databases support and SSAS support below
  3. Settings
  4. Monitoring
  5. Diagnostics

14. in progress Basic filter control

  1. in progress Creating a filter control using either a tag new or code
  2. Improved UI/UX
  3. Filtering for a flat table
  4. Filtering for rows and columns in a pivot table
  5. in progress Supported filter type — filter by selection:
    1. Choosing specific field members to display
    2. Searching for members
    3. Selecting or deselecting all members at once
  6. Sorting members for a pivot table
  7. Support for more complex filters is planned for later — see Advanced filter control below

15. in progress API and its documentation for the implemented features

  1. Tags to create visual controls new
  2. Dataset and state new
  3. And much more

16. Basic migration adapter for initial backward compatibility for the implemented features

  1. Backward compatibility for initializing the component
  2. Backward compatibility for loading reports:
    1. Data source definition
    2. Metadata in the data source for CSV and JSON
    3. Slice definition (only those features that have already been implemented)
  3. Backward compatibility for API for the implemented features
  4. Further backward compatibility is planned for later — see Saving and restoring reports and others below

Flexmonster Pivot 3.0-preview.1 October 2025

We will prepare the initial deliverables for you: a downloadable package with the component and documentation on the implemented features.

You can download the component, read the documentation, connect it to your data, and see it in action.

17. Integration with popular frameworks

  1. Wrapper for React
  2. Wrapper for Angular
  3. Wrapper for Vue

Flexmonster Pivot 3.0-preview.2 Fall 2025

The updated downloadable package and documentation will now include newly added features.

18. Advanced data types support

  1. Support for the following data types: month, weekday, and more
  2. The mapping defines how fields from the data source are treated and presented within the component’s UI:
    1. Explicitly define the data type for a field
    2. Specify a caption for a field
    3. Hide a field from the component
    4. Group several fields in a folder within the field list
    5. Define available aggregations for a field
    6. Define available aggregations for fields of a particular data type
    7. Create several fields from one field
  3. Support for multilevel hierarchies
    1. Configuring multilevel hierarchies through metadata in JSON and CSV
    2. Configuring multilevel hierarchies through the data schema in the Flexmonster Pivot server
    3. Configuring multilevel hierarchies through the mapping

19. Advanced pivot table

  1. Report filters — filtering on the fields included in the report filters box in the pivot field list
  2. Advanced options for layout
    1. Toggling totals and subtotals on/off: in rows, in columns, or even for each field new
    2. Positioning of totals and subtotals: at the top or the bottom
    3. Classic view
  3. Drilling up and down through multilevel hierarchies
  4. Support for “show as” on top of aggregations: % of, difference of, running of, index
  5. Population standard deviation and sample standard deviation aggregations
  6. Rearranging fields in the grid by dragging them

20. Advanced filter control

  1. Improved UI/UX
  2. Support for more complex filters:
    1. Conditional filters
    2. Value filters

21. in progress Toolbar

  1. “Connect” button to connect to the data source
  2. “Open” button to open a report
  3. “Save” button to save the report
  4. “Export” button
  5. “Print” button
  6. done “Fields” button to open a flat or pivot field list control
  7. “Options” button
  8. “Format cells” button
  9. “Conditional formatting” button
  10. done “Fullscreen” button
  11. An ability to add your buttons
  12. An ability to customize the toolbar

22. Dashboard feature new

  1. Complete control over the positioning of all elements on the web page, including pivot tables, flat tables, field lists, toolbars, charts, filters, conditional formatting controls, options controls, and more
  2. An ability to connect multiple controls to the same dataset
  3. An ability to connect different controls to various datasets within a single dashboard
  4. An ability to manipulate data in one control and view results in others if they are linked
  5. Optimal data loading for linked controls, ensuring no data duplication
  6. Combining built-in controls with third-party controls in one dashboard

23. Saving and restoring reports

  1. Concept of a report for the dashboard
  2. Saving a report
  3. Restoring a report
  4. Backward compatibility for restoring 2.9 reports

24. API for third-party charts integration

  1. An ability to use third-party charts in dashboards

25. Format cells

  1. Creating a format cell control using either a tag new or code
  2. Improved UI/UX
  3. Applying formatting to numeric values in the table
  4. API
  5. How cells formatting is saved in a report
  6. “Format cells” button in the toolbar
  7. Backward compatibility for restoring formatting from 2.9 reports

26. Options control new — a universal UI that displays options for the connected control

  1. Creating an options control using either a tag new or code
  2. UI
  3. A lot of cool options for different controls
  4. API
  5. How options are saved in a report
  6. “Options” button in the toolbar
  7. Backward compatibility for restoring options from 2.9 reports

27. Calculated values

  1. Adding calculated values
  2. Improved UI/UX
  3. API
  4. How calculated values are saved in a report
  5. Backward compatibility for restoring calculated values from 2.9 reports

28. Conditional formatting

  1. Creating a conditional formatting control using either a tag new or code
  2. Improved UI/UX
  3. Applying conditional formatting rules to values in the table
  4. API
  5. How conditional formatting rules are saved in a report
  6. “Conditional formatting” button in the toolbar
  7. Backward compatibility for restoring conditional formatting from 2.9 reports

29. Autocalculation bar for pivot tables and flat tables

30. Exports

  1. Support for different export formats:
    1. PDF
    2. Excel
    3. HTML
  2. Print
  3. Share the report
  4. Improved UI/UX
  5. API
  6. “Export” button in the toolbar

31. Drill-through feature

  1. Showing details about all facts that are under each aggregated cell
  2. Opening the drill-through view on a cell by double-clicking
  3. Improved UI/UX

32. Internationalization (i18n) / Localization (l10n)

  1. I18n: date format new
  2. I18n: number format new
  3. L10n of UI

Flexmonster Pivot 3.0-alpha Winter 2025/26

The updated downloadable package and documentation will now include newly added features. In comparison to Flexmonster Pivot 3.0-preview versions, more engineers may be willing and ready to use this version in their projects.

33. Full accessibility support

  1. Built-in high-contrast CSS theme
  2. Keyboard navigation support for all features
  3. Full compatibility with screen readers
  4. Сonformance to the WCAG 2.1 accessibility standard

34. RTL feature new

35. SQL databases support

  1. An ability to connect external databases to the Flexmonster Pivot server

36. SSAS support

  1. Flexmonster Accelerator becomes an integral part of the Flexmonster Pivot server

37. Custom data source API support

  1. Support for the backward compatibility of the custom data source API implemented by our clients in version 2.9

Flexmonster Pivot 3.0 2026

Flexmonster Pivot 3.0 is now the recommended version for all Flexmonster customers.

38. Charts

  1. Built-in simple charts
  2. Built-in pivot charts

39. MongoDB connector

40. Elasticsearch connector

Flexmonster Pivot 3.1

Table of contents