Task 2

Create a detailed table showing daily distribution for the considered data and put it on your first [TIS]Board page.

Input data node:   A01 [>] working time


Steps -> Operators

Conversion    -> Convert "From-Date/From-Time/To-Time"

Compute working hours per duty   -> Formula operator (row-by-row) (4.0) = Formeloperator

Scale to daily data  -> Scaling 8.0

Compute daily percentages  -> As a percentage 4.0

Pivotize your data  -> Create Pivot Table V2

Format your table and data  → Format columns 2.0; Replacing null values; General Calendar; Rename, reorder and delete columns

TIS Board operator → TIS Board - Adjust portlet if column changes 1.0

Create a simple grid portlet → Conditional Formatting for Grids

Add portlet to your first [TIS] board page