Release notes

We use automated processes that enable us to release new features to our application on an ongoing basis. There are no preset release dates, we release new features and improvements as soon as they are ready and tested. We'll ensure that your existing configuration and data will never be adversely affected by any release.

This page includes only the major releases that contain visible improvements to users. Minor releases are not mentioned as they contain only technical or server-side improvements.

Release 307 - Jan 22, 2018

New features:
  • You can now mark imports as In batch, which ensures they can only be run as part of import batches.
  • You can now assign a color to every group in My account - Groups, which changes the page header color on all items that belong to that group. This makes user navigation more intuitive.
  • Replace data using filter values in Define imports and Define models - import queriesgives you more control over how to selectively replace data.
  • Define custom functions in My account - Profile which you can use in any expression across all your objects.
  • Report and query filters can now include functions, formulas, and calculations.
  • We have added new functions: COUNTROWS, PERCENT, RECALC, REPEAT, SORT, TOPX.
Improvements:
  • We made 60+ small improvements to existing functionality
  • We upgraded the database and increased the server capacity
  • Improvements to exporting data to Excel and PDF, and printing
  • Improvements to the popup editor for expressions, formulas, and filters
  • Improvements to the UI and its presentation on tablets

Release 306 - Oct 10, 2017

New features:
  • You can now create Import batches in Define Models which enables you to automatically run related imports every time the Save button is clicked in Run Models.
  • The SELECT() function now has new optional parameters enabling you to define and filter the list of values that will be shown for user selection. The list of values can now be obtained from any other data set and can be filtered on-demand. By using SELECTED() in filters you can create cascading selections (i.e. list of values can be filtered based on other selected values).
  • A new popup editor for convert and filter expressions in reports and queries, and similarly for cell formulas in models, makes it much easier to work with functions, expressions, and field values. This popup window also shows brief help documentation on every function.
  • We have added additional permissions ("Clear all data", "Export data", and "Access API") in Define data sets to give you more granular control over your data.
  • We have added additional permissions ("Edit layout, "Save model", "Export data" and "Access console") in Define User roles to give you more granular control over what users are allowed to do.
  • We have added more new functions: COMPOUND, CONVERT, FVSCHEDULE, DAYNUM.
Improvements:
  • Significant performance improvements in generating reports and models
  • Changes in the definition of selection parameters are now immediately reflected in Define Imports, Define Reports, and Define Models.
  • When clicking the Save button in Run Models, all editable sheets are now saved in one single action.
  • Exports to Excel now include cell formats and colors.
  • Dropdown date pickers now also accept manually entered dates
  • Various small usability improvements

Release 305 - Sep 12, 2017

New features:
  • You can now create Import batches which enables you to run multiple imports as one single action.
  • Report queries in models now have dynamic subtotals, which -when combined with editors and formulas- enables you to build highly interactive models.
  • New option Subtotalise adjacent columns in Define Models for report queries.
  • New options Review query in Define Models to help you review how queries are being used across the model.
  • In Define models, when saving, validation is performed on the usage of queries by cell editors and cell functions.
  • A new option to dynamically hide or show the Save button in Run Models, which you can trigger by some logic in your model.
  • Publish dashboards to user roles as well as to individual users.
  • Additional rights in user roles that determine whether users can edit or publish dashboards.
  • New option Transfer objects to export the configuration of objects to a file.
  • We have added more new functions: COMPARE, ROWNUM, DEPRECIATE, HIDESAVE, ADDRESS, INDIRECT, PERIODRANGE, COUNTDISTINCT, TRANSPOSE.
Improvements:
  • Upgraded the web libraries and database server
  • Multiple optimisations in data imports, report generation, and models
  • We have added more tooltips to various popup windows
  • Various small usability improvements

Release 304 - Aug 21, 2017

New features:
  • The SELECT() function in report and query filters now has an optional parameter to specify whether the selection is optional or mandatory, and whether it is single-select or multi-select (read more).
  • The selected values on your dashboard are retained if you click Save.
  • Model sheets can be re-ordered and copied.
  • Dynamic filtering of dropdown editors.
  • New option "All next columns" when transposing data in import files.
  • We added new functions: QUARTER, DEGREES, RADIANS, LABEL, GUID, PENSIONDATE.
  • The functions WEEKDAY, MONTH, QUARTER now have an optional parameter to return configurable text labels.
Improvements:
  • Improvements in editing and formatting of dates and numbers in models
  • Dates are automatically formatted in models when entered
  • Models are being generated much faster

Release 303 - Jul 31, 2017

New features:
  • We have added over 85 new functions for powerful functionality in reports, imports, models, whilst at the same time offering maximum compatibility with Microsoft Excel:

    DATEDIF, DATEVALUE, TIMEVALUE
    DAYSWITHIN, PERIODSWITHIN
    FIRSTDATE, LASTDATE
    HOUR, MINUTE, SECOND
    SOMONTH, EOMONTH
    FIRSTVALUE, LASTVALUE
    DCOUNTA, DRANGE
    HLOOKUP, VLOOKUP
    SUMPRODUCT, SUMSQ
    CEILING, FLOOR
    FIND, EXTRACT, INDEX
    COLUMNS, ROWS
    CELLS, RANK
    EVEN, ODD
    AND, OR, XOR
    IFS, ISTEXT
    FIXED, NOT
    ISBOOLEAN, ISTRUE
    COUNTBETWEEN
    RANDBETWEEN
    WEBSERVICE
    MEDIAN, MODE
    FV, PV
    NPV, RRI
    EFFECT, NOMINAL
    FORECAST
    VARP, STDEVP
    FACT, EXP, PI
    LN, LN10
    LOG, LOG10
    COS, COSH, ACOS, ACOSH
    SIN, SINH, ASIN, ASINH
    TAN, TANH, ATAN, ATAN2, ATANH
    USER, TENANT, OBJECT
    HIDECOLUMN, HIDEROW
    ROWACTION
    TOOLTIP
    STRIP
    GETPERIOD

  • You can now include data queries in Planner cell editors to use data-driven and dynamic planning patterns.
  • The DLIST function has been renamed to DINDEX for more consistency.
  • New option to update or upsert existing data in imports and save queries.
  • In Define data sets you can now visually select and clear data rows.
  • In Define data sets you can now export all data rows, even for large data sets.
  • New option to Publish dashboards to other users.
  • We added additional account security settings in My account - Profile.
  • New API endpoint to clear selected data rows from a data set.
Improvements:
  • We have completely redeveloped the dashboard pages. They now offer better layout possibilities and a more stable look & feel.
  • Various usability improvements to models.
  • We have improved the auto-scaling of charts and gauges.
  • In Define models, the preview of query data is improved.
  • In Define models - save queries, convert and filter expressions can now reference any source column in your model.
  • In Define models, we have expanded the number of toolbar buttons to give more one-click access to functions.
  • The DAYS and PERIODS functions (and their new counterparts DAYSWITHIN and PERIODSWITHIN) can now accept either full dates, periods, or years as parameters.

Release 302 - Jun 10, 2017

New features:
  • Added new functions: ROUNDUP, ROUNDDOWN, CLEAN, and VALUE.
  • Added new query functions: DVALUE, DCOLUMNS, and DROWS. These functions (in combination with queries) enable you to build extremely powerful and dynamic models.
  • Define models: new QUERY(ID, range) function which binds a report query to a cell range in a model. This replaces the previous "QUERY: name" placeholder.
  • Define models: a new option for Save queries "when empty values" enables you to either skip entire rows when a field is empty, or repeat the values from the previous row (which is useful if your model data is grouped).
  • Define models: you can now create cell formulas with references to cells in other sheets. The syntax is identical to Excel: sheet!cell (for example: =Sheet1!A1 * 100).
  • Export data or print: this rewritten option enables you to export data to Excel, CSV, JSON, PDF, or PNG, as well as print a report, chart, or model in an optimized manner (choosing paper size and orientation, hiding all navigation emements, and rendering the content in an optimized way).
  • My profile: new settings for date and number format. This replaces the previous "Regional settings" as it allows better control over formatting of data.
Improvements:
  • Various usability improvements to models.
  • Various improvements to functions, and alignment of syntax and parameters to the functions used in Microsoft Excel.
  • Improvements to rendering of charts.