Home > Features > Options > Stratify
Feature Location: Options tab | Stratify
Availability: Version 1.1+
Figure 1: Stratify Setting Form
The stratify feature divides a report into multiple worksheets. The Stratify Field (Figure 1, Item 2) determines which data is placed in each worksheet. All records with the same value in the Stratify Field will be on the same worksheet.
For example, this feature can be used to separate all open defects into reports based on their Target Release. Each worksheet would then only include the tickets that will be fixed in that release.
Figure 2 depicts this example. The report on the Stratify worksheet (Figure 2, Item 1) has the stratify settings shown in Figure 1. When the report is generated, all open defects are on the Stratify worksheet. In addition, it automatically created 4 new worksheets (Figure 2, Item 3): RZ_2.1, RZ_2.0, RZ_1.1 and RZ_1.0. Each of those worksheets only contains the defects targeted for that release. Figure 3 shows the report generated for Release RZ_2.1.
|Figure 2: Stratify Report||Figure 3: Automatically Generated Stratification Report|
|Figure 4: Stratify Value Variable |
The example spreadsheet contains a worksheet named Stratify. That worksheet contains a report with stratification enabled. The Stratify Field is set to the Submitter field. When the report is run, it will create a worksheet for each submitter. The report also shows how to email the report to each submitter (see the Email tab of the report configuration). To test the email feature you must first change the Workbook Setting for Email back to Worksheet.