Exercise 2.1
Task 1
Prepare a list of all accounts
Step | Operator / Portlet | Concept | Result |
|---|---|---|---|
Based on the original data find all accounts | column "Account" |
Task 2
Prepare list of all month in selected time range.
Step | Operator / Portlet | Concept | Result |
|---|---|---|---|
Compute selected time range | columns "From" and "To" | ||
Scale to monthly data | Scaling 8.0 | one row for each month in time range | |
Combine all month with all accounts |
Task 3
Add missing data to monthly distribution
Step | Operator / Portlet | Concept | Result |
|---|---|---|---|
Add missing month and account to selected data | |||
Replace null values with 0.0 |