NEW An ability to use showEmptyValues separately by rows and columns was added.
NEW flexmonster.js was migrated to ES6 JavaScript standard to utilize modern browsers' features. Note: IE11 users should stay on old ES5 build (flexmonster.es5.js).
NEW Data Server A new configuration property DecimalSeparator was added for csv files.
NEW Data Server A new configuration property CacheSizeLimit for caching responses was added.
FIX Data Server The issue with loading big datasets from databases was fixed.
FIX The issue with filtering when showEmptyValues is enabled was fixed.
FIX The exception when the calculated value formula calls itself recursively was fixed.
FIX The issue when a calculated value could have the uniqueName that is already present in the data source was fixed. Now, if the data source already contains a field with the specified uniqueName, Flexmonster shows values for this field and ignores the formula property.
FIX The "Promise is undefined" exception when using IE11 and RequireJS was fixed.
FIX The issue with overwriting filters in a slice for third-party charts integration was fixed.
FIX The issue with formatting (decimalPlaces/maxDecimalPlaces) not being applied to large numbers in exponential notation was fixed. Note: min decimal places for e-notation numbers is 1.
FIX For the custom data source API, the issue with skipping the folder property from a response to a /fields request was fixed.
FIX For the custom data source API, the exception when the "distinctcount" aggregation of a string data type field is used in a calculated value was fixed.
FIX The exception with expanding rows in the Custom API was fixed.
FIX The issue with the empty column in the drill-through view using the custom data source API was fixed.
FIX Now "% of Parent Column Total" and "% of Parent Row Total" aggregations work correctly in calculated values.
FIX The issue with switching between the flat form and charts was fixed.
FIX The issue with the inactive Apply button in the flat form Field List was fixed.
FIX The issue with parsing dimensional data with dates was fixed.
FIX The issue with exporting to Excel was fixed.
FIX The exception when removing a field from the flat form was fixed.
FIX The issue with the flat form when using custom data source API and hierarchies with multiple levels was fixed.
FIX For SSAS, the issue when the same measure is used in a report several times with different aggregations was fixed.
FIX React Native wrapper The issue with the component not resizing when the orientation is changed was fixed.
FIX flexmonster.d.ts The following properties were added: rightGroup, fieldListPosition, the measure property in type ConditionalFormat, the sort property in type Hierarchy.
NEW mapping The mapping property now allows loading mapping from the remote source.
NEW The new hook customizeChartElement to apply customizations for charts was added.
NEW For CSV export, the new option alwaysEnclose was added to enclose all fields in quotes.
FIX Elasticsearch The issue with incorrect aggregations for non-numeric fields was fixed.
FIX The issue with formatting (decimalSeparator) not being applied to large numbers in exponential notation was fixed.
FIX The issue with report filters not re-positioning by drag and drop to the last position was fixed.
FIX custom data source API The issue with extra values (if sent in the response) overwriting values on the grid was fixed.
FIX The issue with multiple columns having running totals aggregation was fixed.
FIX The issue when hidden fields in mapping broke reports for CSV data source was fixed.
FIX The issue with data loading ticker was fixed.
FIX The issue with loading empty data was fixed.
FIX The issue when non-empty availableAggregations array for SSAS data source KPIs was returned by getMeasures() was fixed.
FIX The issue when availableAggregations array for SSAS data source KPIs was saved in the report or returned by getReport() was fixed.
FIX The exception when a conditional formatting rule is applied on top of several measures one of which has a 'differenceofrow' aggregation applied was fixed.
FIX If a measure is not selected for a slice and if its aggregation property is the only that differs from the default one, this measure is not being saved to the report.
FIX The issue with the active levels in hierarchies for custom data source API was fixed.
FIX Data Server The issue with count aggregation on data with empty values was fixed.
NEW The "Difference" aggregation "difference" is split into two different aggregations: "Difference of Column" "differenceofcolumn" and "Difference of Row" "differenceofrow". If the deprecated "Difference" aggregation "difference" is used, Flexmonster Pivot will automatically treat it as "Difference of Column" "differenceofcolumn".
NEW The "% Difference" aggregation "%difference" is split into two different aggregations: "% Difference of Column" "%differenceofcolumn" and "% Difference of Row" "%differenceofrow". If the deprecated "% Difference" aggregation "%difference" is used, Flexmonster Pivot will automatically treat it as "% Difference of Column" "%differenceofcolumn".
NEW The "Running Totals" aggregation "runningtotals" is split into two different aggregations: "Running Totals of Column" "runningtotalsofcolumn" and "Running Totals of Row" "runningtotalsofrow". If the deprecated "Running Totals" aggregation "runningtotals" is used, Flexmonster Pivot will automatically treat it as "Running Totals of Column" "runningtotalsofcolumn".
NEW The following aggregations were introduced for the string data type in JSON and CSV data sources:
"percent""percentofcolumn""percentofrow""percentofparentcolumntotal""percentofparentrowtotal""index""differenceofcolumn""differenceofrow""%differenceofcolumn""%differenceofrow""runningtotalsofcolumn""runningtotalsofrow"NEW A new "negativeNumberFormat" property was added to the Format Object.
NEW A new option distinguishNullUndefinedEmpty was added to separate empty values from null and undefined.
NEW Now the flat view shows all levels with year/month/day and year/quarter/month/day date types.
NEW Data Server Now basic Flexmonster Data Server functionality is available as a DLL at NuGet.
NEW Data Server New properties for HTTPS configuration were added.
FIX The sorting issue with hierarchies that have numeric levels was fixed.
FIX custom data source API The exception when only one level of a hierarchy is active was fixed.
FIX custom data source API The issue with expanding hierarchies was fixed.
FIX custom data source API The issue while reading year and month types of levels was fixed.
FIX custom data source API The issue with missed measures in the calculated values was fixed.
FIX custom data source API Support of id's instead of names for members was restored.
FIX custom data source API The incorrect saving of the mapping object to the report after switching between compact, classic, and flat tables was fixed.
FIX Data Server The issue with nulls in the first JSON object was fixed.
FIX The issue with the blank column in the drill-through view was fixed.
FIX The issue with saving inactive calculated values to the Report Object was fixed.
FIX Mapping for CSV is now applied by column names instead of column indexes.
FIX Mapping for CSV is now applied on top of the default structure (so it does not require to enumerate all fields).
FIX The option for hiding subtotals on rows was improved for the compact view (empty rows are hidden).
NEW The following front-end built-in aggregations were introduced for the custom data source API:
"percent""percentofcolumn""percentofrow""percentofparentcolumntotal""percentofparentrowtotal""index""difference""%difference""runningtotals"They will appear automatically for numeric fields if at least one aggregation is supported on the back end, for example, "sum".
NEW The "runningtotals" aggregation was introduced for SSAS and Mondrian data sources.
NEW A new "filters" mapping property was added.
NEW Data Server Now Flexmonster Data Server can be run on HTTPS.
NEW Data Server Now Flexmonster Data Server supports last, current, and next date filters.
FIX The unused properties were removed from /select requests in the custom data source API.
FIX The error handling for the index data source property was improved for the custom data source API.
FIX The issue with inappropriate saving of availableAggregations to the report.slice was fixed.
FIX The options.grid.showEmptyValues option was moved to options.showEmptyValues.
FIX The issue with the numeric value filter not getting applied in the flat form was fixed.
FIX 'Content-Type' header was removed from the GET requests for loading data.
FIX The issue with expanding rows on the classic form was fixed.
FIX custom data source API The issue with hierarchies containing capital letters in level names was fixed.
FIX custom data source API The issue with converting the last, current, and next date filter queries to the between query was fixed.
FIX The issue with "requestHeaders" in custom data source API was fixed.
FIX The issue with the hierarchy's caption was fixed.
FIX The issue with changing drill-through slice was fixed.
FIX The issue with "dimensionUniqueName" in the mapping object was fixed.
FIX Data Server The issue with null members was fixed.
FIX custom data source API The issue with unbalanced hierarchies was fixed.
FIX Now the nullValue property from the Format Object works for the string data types.
NEW Flexmonster Data Server is now available! It significantly reduces the time of data loading and enables analyzing large datasets (read docs).
NEW Multilevel hierarchies are now supported for the custom data source API.
NEW Advanced mapping features for the custom data source API and CSV were added.
NEW The dataSource.withCredentials property is now available for the custom API data source.
NEW Windows authorization is now supported for the Accelerator.
FIX The issue with an odd decimal part for large integers was fixed.
FIX The issue with resetting captions after the updateData() API call was fixed.
FIX The issue with the date value filter was fixed.