Stratification Table sub-buckets allows users to create sub buckets in their Stratification Tables. This set up tool allows multiple nested buckets to be created, akin to a pivot table, and display totals for each Bucket.
Detailed Functionality Description:
The set-up allows users to define buckets for multiple sub-segmentation. Totals and subtotals can be selected for all buckets and all aggregated metrics in the table.
Buckets Set-up Wizard:
Multiple data fields may be chosen out of a list of available data fields for the selected asset types. The order of the selected data fields dictates the nested order. The first selected field is the primary bucket, second is for defining the inner buckets within the primary and so on. The order of the selected fields may be changed any time by dragging the field name.
For each selected data field, stratification criteria are defined, using one of the bucket set-ups tools. The stratification criteria are saved while moving from one field tab to the other.
Sub-Bucket Widget:
The final table displays the selected segmentation of the collateral. The layout presents primary buckets, including their internal stratification, with separate colors. No Group totals, for assets that fall outside the selected criteria are presented at sub-buckets as well as primary buckets. See example below: