**TABLE OF CONTENTS**

## Summary

When you land on the Strats page, dv01 will automatically generate and display a set of columns based on the fields in your dataset. We also offer the ability to create and strat by your own columns; this is particularly useful in our Tape Cracker product, where you likely have custom fields added to your dictionary.

To create custom columns, click the *Edit Columns* icon in the top right corner of the Global Strat Settings card or in the top right corner of one the primary field strat cards. This will open a list of dv01 columns, along with columns created by anyone else in your organization.

Click the *Create New Column* button. Name your column and select the appropriate aggregation (more information on this below). Fill out the parameters, click *Save*, and then use new column to reconfigure your strat columns.

Keep reading for a list of the available aggregation functions, with examples for using each one.

## Supported Aggregation Functions

### Average

- Returns the average of the specified
*target column.* **Ex.:**to create a column to display the average current actual balance of a loan pool, select*Average*as the function and*Current Actual Balance*as the target column.

### Count

- Returns the count of loans that meet the specified
*filter column*and*filter condition value.* **Ex.:**to create a column that counts the loans in California, select*Count*as the function,*Property State*as the filter column, and*California*as the filter condition value.

### Maximum

- Returns the maximum value of the specified
*target column.* **Ex.:**to create a column that returns the maximum loan level Current Actual Balance value, select*Maximum*as the function and*Current Actual Balance*as the target column.

### Minimum* *

- Returns the minimum value of the specified
*target column.* **Ex.:**to create a column that returns the maximum loan level Current Actual Balance value, select*Maximum*as the function and*Current Actual Balance*as the target column.

### Non-Zero Weighted Average

- Returns the non-zero weighted average of the specified
*target column*,*Weighted By*value. You can only weight columns by numeric columns. **Ex.:**to calculate the non-zero average of*Current Actual Balance*weighted by original balance, select*Non-Zero Weighted Average*as the function,*Current Actual Balance*as the target column, and*Original Balance*as the Weighted By value.

### Nth Largest Aggregated Percentage

- Returns the
*target column*value with the*nth*largest**total***metric*(i.e., the nth largest sum of the metric of all loans for a specific*target column*value), along with the percentage the*target column*value it represents out of the sum of the entire*metric*column. This function is currently only available for Tape Cracker. **Ex.:**to display the states with the 3rd largest current actual balances as columns, select*Nth Largest Aggregated Percentage*as the function,*Property State*as the target column,*Current Actual Balance*as the metric, and*3*as the nth value.

### Nth Largest Loan Value

- Returns the
*target column*value with the*nth*largest**individual**loan level*metric*value, along with the value itself. This function is currently only available for Tape Cracker. **Ex.:**to display the property state of the loan with the largest current actual balance value, select*Nth Largest Loan Value*as the function,*Property State*as the target column,*Current Actual Balance*as the metric, and 1 as the nth value.

### Percent of Total

- Returns the percentage of the total
*target column*sum represented by the selected*filter column value*. **Ex.:**to determine how much of a pool's current actual balance is made up of California loans, select*Percent of Total*as the function,*Current Actual Balance*as the target column,*Property State*as the filter column, and*California*as the filter column value.

### Sum** **

- Returns the sum of the
*target column*selected. **Ex.:**to calculate the sum of the*Current Actual Balance*for each bucket in your strat configuration, select*Sum*as the function and*Current Actual Balance*as the target column.

### Weighted Average

- Returns the weighted average of the specified
*target column*weighted by the field selected as the*Weighted By*value (similar to the*Non-Zero Weighted Average*function). You can only weight columns by numeric columns. **Ex.:**to calculate the weighted average of*Current Actual Balance*weighted by original balance, you would select*Weighted Average*as the function,*Current Actual Balance*as the target column, and*Original Balance*as the Weighted By value.

## Filtering Your Column

Every aggregation function allows you to filter using one of the defined value fields in your dataset. The *filter column* represents the field on which you want to filter the dataset(s), and the *filter column value* represents the value you are interested in.

For certain aggregation functions, such as *Percent of Total, *inputting a filter column and value is critical to creating a column that makes sense; for other aggregation functions, such as *Maximum , *the filter column and value are optional.