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 | 2 columns "From" "To" | ||
Compute working hours per duty | column "Hours" | ||
Compute totals (absence, working) | column "TotalHours" | ||
Compute percentages of type of account | column "Rate" | ||
Prepare data node "A02 [>] Gauge template row" | |||
Prepare data for gauge | 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 | |||
Add portlet to your first TIS Board page |