Task 1

Prepare a list of all accounts

Step

Operator / Portlet

Concept

Result

Based on the original data find all accounts

Identifier instances


column "Account"

Task 2

Prepare list of all month in selected time range.

Step

Operator / Portlet

Concept

Result

Compute selected time range

Statistical evaluations


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

Merge data 5.0




Task 3

Add missing data to monthly distribution

Step

Operator / Portlet

Concept

Result

Add missing month and account to selected data

Merge data 5.0



Replace null values with 0.0

Replacing null values