Inforiver Writeback Matrix March 2025 - v4.3 - Time series formulae

In this release, explore the new range of time series formulas to gather business insights from your time-based data. We've also made Inforiver Writeback Matrix more secure with internal software version upgrades and API updates.

New time series formulae

We've introduced a range of easy-to-use formulas for manipulating time series data. Whether you are tracking financial trends, analyzing sales performance, or identifying anomalies, these formulas enable you to filter and compare data efficiently.

Let's look at a monthly sales report. The VALUEAT function can be applied to return the value of the sales measure for a particular month(s) preceding or after the current month. This is useful in evaluating the financial performance relative to other periods. In this case, for February, the VALUEAT function returns the sales for January. Similarly, for March, the VALUEAT function returns the sales for February.

The SHIFT function returns the date after shifting the current month by a specified number of months. For January, the SHIFT function returns March 01st.

In the same sales report, we can use the FILTER function with an aggregation formula like MIN/MAX/SUM to aggregate only the cells that satisfy a certain condition. In this scenario, we are summing up the sales only when the sales is greater than 1000. The FILTER measure is blank for the "Fasteners" row as none of the cells have sales > 1000.

The AGGREGATE function has been used to find the minimum sales between 6 and 3 months before the current date.

We've used the MOVINGSUM and MOVINGAVERAGE to calculate the rolling sum and average of the sales measure over a defined period of time - in this case, 2 months. For January, the moving sum is the sum of the sales across January, February, and March. A similar calculation is used for moving average as shown below.

Other enhancements and bug fixes

• As part of our commitment to security, we have identified and resolved high-priority vulnerabilities, strengthening the overall security of the Inforiver Writeback Matrix.

• The LastUpdatedAt and LastUpdatedBy housekeeping columns did not reflect changes made in slicer selections. This issue has been resolved.

• When the cell value is deleted in the source report for a formula measure referencing a data input number field, the Infobridge preview was throwing an error. This issue has been rectified, and the updated null values are displayed correctly in the bridge.