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 days in selected time range.
Step | Operator / Portlet | Concept | Result |
|---|---|---|---|
Compute selected time range | columns "From" and "To" | ||
Scale to daily data | Scaling 8.0 | one row for each day in time range | |
Combine all days with all accounts |
Task 3
Add missing data to daily distribution
Step | Operator / Portlet | Concept | Result |
|---|---|---|---|
Add missing days and account to selected data | |||
Replace null values with 0.0 |