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

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.

We have used months in these examples for demonstration purposes. Year and quarter are also supported in time series formulas.

SHIFT and VALUEAT

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.

FILTER and AGGREGATE

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.

MOVINGSUM and MOVINGAVERAGE

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.

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.

Last updated

Was this helpful?