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.

FUNCTION NAME	DESCRIPTION
VALUEAT	Returns the value of a measure for a specified date or a date shift relative to the current column
MOVINGSUM	Returns the sum of a measure over a specified date range
MOVINGAVERAGE	Returns the average of a measure over a specified date range
SHIFT	Shifts a date by a specified time period like a month, quarter or year
AGGREGATE	Performs a specific aggregation like min/max/avg/sum on a measure over a specified time range
PERIOD_RANGE	Returns a date range array between two specified dates
FILTER	Returns the measure values over a time range, only values satisfying the filter condition will be returned

FILTER

SHIFT

VALUEAT

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 were not reflecting changes made in slicer selections. This issue has been resolved.

In this example, we've used the Power BI-certified Inforiver SuperFilter visual to filter the regions.

Context awareness for housekeeping columns

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