Limitations

The time-series matrix transformation currently has the following limitations.

• Sorting and filtering cannot be applied for the child column of the matrix column.

• The option setting "Recalculate Formula on Record Update" is not currently available for the formula field child column of the matrix column.

• Currently only one type of object can be displayed inside one matrix column.

• For records to which time-series matrix transformation is applied, the time-series value must always be set to the first date value in that series. For example, when the display interval of the time-series matrix is set to "Monthly", records displayed in the "April 2024" series must have a date field value of "2024-04-01".

• If there is more than one record in the related list that matches a certain time series value, the first record found by the Mashmatrix Sheet is selected and used. Any priority or filter condition cannot be specified currently.

• If you clear the value displayed in the matrix column cell, a blank value is written to that field, not deleting related records automatically. Therefore, if a time-series matrix transformation is performed on a related list that includes required fields, errors for required field may occur when values ​​are cleared to blank and saved.