Flexmonster 3.0 Roadmap

Planned features and key release milestones

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 new

3. done 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. done A total row that aggregates data for each column
    1. 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. Choosing an aggregation function for each column using the field list
    3. Managing visibility of a total value cell for any column using the field list
    4. An option to position the total row either at the top or the bottom of the table
  5. later Rearranging columns in the grid by dragging them

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

  1. done Creating a flat field list 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. doneChoosing an aggregation function for each field, which will be used in the total row of the flat table
  9. doneManaging visibility of a total value cell for any column

5. done 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, Conditional filters, and Value filters below

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

  1. done Creating a pivot field list 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. done 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 JSON and CSV formats — data can be imported in both JSON and CSV 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 string), datetime (ISO string or timestamp in milliseconds)
  3. Improved autodetection of data types during parsing
  4. Support for embedded 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 string), 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. done Flexmonster Admin Panel — GUI for the Flexmonster Pivot server

  1. done Improved UI/UX of the cross-platform desktop application
  2. done Management of data sources
    1. done JSON/CSV
    2. done Management of data schemas
    3. later Support for more data sources is planned for later — see SQL databases support and SSAS support below
  3. done Settings
  4. done Monitoring
  5. done Logs
  6. done Authorization (security)

14. done Basic migration adapter for initial backward compatibility for the implemented features

  1. done The composite Flexmonster control as a container for a table, toolbar, and field list
  2. done Backward compatibility for initializing the component
  3. done Backward compatibility for loading reports:
    1. Data source definition
    2. Metadata in the data source for JSON and CSV
    3. Slice definition (only those features that have already been implemented)
  4. done Loading reports via URL
  5. done Backward compatibility for API for the implemented features
  6. later Further backward compatibility is planned for later — see Saving and restoring reports and others below

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

  1. done API reference for the implemented features
  2. done Getting started guides with instructions on how to install the Flexmonster server and embed the Flexmonster UI
  3. done Tutorials for connecting to JSON and CSV data:
    1. Using the Flexmonster server (see docs for JSON and CSV)
    2. Using the built-in client-side parsers (see docs for JSON and CSV)
  4. done Info on ways to tune your data in Flexmonster:
    1. Schema on the server side
    2. Mapping on the client side
    3. Embedded JSON and CSV metadata on the client side
  5. done Guides on available server configurations
  6. in progress Docs about new dataset and state concepts new

Flexmonster Pivot 3.0-preview.1 October 9, 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.

16. done Basic filter control

  1. done Creating a filter control using either a tag new or code
  2. done Improved UI/UX
  3. done Filtering for a flat table
  4. done Filtering for rows and columns in a pivot table
  5. done 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. done Report filters — filtering on the fields included in the report filters box in the pivot field list
  7. later Support for more complex filters is planned for later — see Conditional filters and Value filters below

Flexmonster Pivot 3.0-preview.2 March 12, 2026

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

17. in progress Sorting

  1. testing Sorting members in a pivot table
  2. in progress Sorting values in a specific row or column of a pivot table
  3. later Sorting rows in a flat table based on multiple columns using the “Ctrl” or “Command” key

18. in progress Integration with popular frameworks

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

19. in progress Conditional filters

  1. Improved UI/UX
  2. in progress Supported filter type — conditional filters

Flexmonster Pivot 3.0-preview.3 April 2026

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

20. 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

21. 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

22. in progress Toolbar

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

Flexmonster Pivot 3.0-preview.4 June 2026

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

23. API for third-party charts integration

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

24. 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” tab in the toolbar
  7. Backward compatibility for restoring formatting from 2.9 reports

25. 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” tab in the toolbar

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” tab in the toolbar
  7. Backward compatibility for restoring options from 2.9 reports

27. in progress Advanced data types support

  1. Support for the following data types: month, weekday, and more
  2. in progress The mapping defines how fields from the data source are treated and presented within the component’s UI:
    1. done Explicitly define the data type for a field
    2. done 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

28. Advanced pivot table

  1. 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 new
    3. Classic view
  2. Drilling up and down through multilevel hierarchies
  3. Support for “show as” on top of aggregations: % of, difference of, running of, index
  4. Population standard deviation and sample standard deviation aggregations
  5. Custom aggregations for grand totals
  6. Rearranging fields in the grid by dragging them

29. Value filters

  1. Improved UI/UX
  2. Supported filter type — value filters

30. 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

31. 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” tab in the toolbar
  7. Backward compatibility for restoring conditional formatting from 2.9 reports

32. Autocalculation bar for pivot tables and flat tables

33. 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

34. Internationalization (i18n) / Localization (l10n)

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

35. Flexmonster CLI for 3.0

Flexmonster Pivot 3.0-alpha 2026

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.

36. 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

37. RTL feature new

  1. Based on the page’s direction, Flexmonster automatically switches between LTR and RTL modes

38. SQL databases support

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

39. SSAS support

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

40. 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.

41. Charts

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

42. MongoDB connector

43. Elasticsearch connector

Flexmonster Pivot 3.1