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 days in selected time range.

Step

Operator / Portlet

Concept

Result

Compute selected time range

Statistical evaluations


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

Merge data 5.0




Task 3

Add missing data to daily distribution

Step

Operator / Portlet

Concept

Result

Add missing days and account to selected data

Merge data 5.0



Replace null values with 0.0

Replacing null values