Task 3

Compute the total work/absence rates and visualize them with a gauge portlet, e.g., an absence rate > 20% is critical.

Input data nodes:  

  • A01 [>] working time
  • A02 [>] Gauge template row


Step

Operator / Portlet

Concept

Result

Combined date and time into one column

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


2 columns "From" "To"

Compute working hours per duty

Formula operator: Date and Time


column "Hours"

Compute totals (absence, working) 

Statistical evaluations


column "TotalHours"

Compute percentages of type of account

As a percentage 4.0


column "Rate"

Prepare data node "A02 [>] Gauge template row"

Create Table



Prepare data for gauge

Filter on columns 1.1

Merge data 5.0

Format columns 2.0




TIS Board - Gauge 1.0

TIS Board operators


Create a gauge portlet in TIS Board format it


Gauge (Portlet)



Add portlet to your first TIS Board page