Examples of fixed level of detail calculations
As we turn our attention to some practical examples of level of detail calculations, we’ll use the Chapter 05 Loans data set contained in the Chapter 05 workbook. The true data set contains many more records, but here is an example of the kinds of data it contains:
|
Date |
Portfolio |
Loan Type |
Balance |
Open Date |
Member Name |
Credit Score |
Age |
State |
|
3/1/2020 |
Auto |
New Auto |
15987 |
9/29/2018 |
Samuel |
...