Flexmonster 3.0 Roadmap

Planned features and key release milestones

Welcome to the Flexmonster Pivot 3.0 roadmap...

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. 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. done 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. done Choosing an aggregation function for each column using the field list
    3. done Turning off aggregation for any column completely using the field list, so its total will not appear in the total row
    4. done 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. doneChoosing an aggregation function for each field, which will be used in the total row of the flat table
  9. doneTurning 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. later 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. in progress Flexmonster Admin Panel — GUI for the Flexmonster Pivot server

  1. done Improved UI/UX of the cross-platform desktop application
  2. in progress Management of data sources
    1. done CSV/JSON
    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. in progress Basic migration adapter for initial backward compatibility for the implemented features

  1. done Backward compatibility for initializing the component
  2. in progress Backward compatibility for loading reports:
    1. done Data source definition
    2. in progress Metadata in the data source for CSV and JSON
    3. done Slice definition (only those features that have already been implemented)
  3. done Loading reports via URL
  4. in progress Backward compatibility for API for the implemented features
  5. done API for the composite Flexmonster control as a container for a table, toolbar, and field list
  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 composite Flexmonster control
  2. done Getting started guide 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
    2. Using the built-in client-side parsers
  4. done Info on ways to tune your data in Flexmonster:
    1. Schema on the server side
    2. Mapping and embedded metadata on the client side
  5. done Guides on available server configurations
  6. later Description of tags to create different UI controls new
  7. later 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. Basic filter control

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

Flexmonster Pivot 3.0-preview.2 Fall 2025

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

17. Integration with popular frameworks

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

Flexmonster Pivot 3.0-preview.3 Fall 2025

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

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

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 new
    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

33. Flexmonster CLI for 3.0

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.

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

35. RTL feature new

36. SQL databases support

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

37. SSAS support

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

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

39. Charts

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

40. MongoDB connector

41. Elasticsearch connector

Flexmonster Pivot 3.1