Period Pattern Report

At first glance a Period Pattern Report may appear very similar to a Multiple Target Report (see the section called “Multiple Target Report”), however there are some significant and important differences. A Period Pattern Report is more flexible, can be defined to accommodate more specific information requirements, and is best suited to the Block Table.

A Multiple Target Report is designed to use information from the Target Table. It collects the targetPrefix information from the "TARGET" column of the table, to determine which unique targets (rows) are to be used to populate the report. A Period Pattern Report collects information based on attribute columns of the data source table, most likely the Block Table. In this sense, the reports differ on where and how the information is collected and summed for the table, giving the user the flexibility to create reports from any table in the Patchworks model.

The Period Pattern Report also allows you to specify which periods should be represented in the output, whereas the Multiple Target Report does not include this option. It also allows you to report on a subset of records in the source data table using a reselect expression.