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

Step

Operator / Portlet

Concept

Result

Combined date and time into one column

(optional)

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


2 columns "From" "To"

Compute working hours per duty

Formula operator: Date and Time


column "Hours"

Scale to daily data

Scaling 8.0



Compute daily percentages of account

As a percentage 4.0


column "Percentage"

Format your table and data 

Format columns 2.0

Replacing null values

Rename, reorder and delete columns

General Calendar


column "Date"

Order by date

Sort Rows



Pivot the table

Create Pivot Table V5


columns "worktime", "sick leave", "holiday"

Create TIS Board operator

TIS Board - Adjust portlet if column changes 1.0

TIS Board operators


Create a simple grid portlet


Simple Grid (Portlet)

Conditional Formatting for Grids



Add portlet to your first [TIS] board page