Table Statistics Column

In Statistic Column it is able to make "your own" Columns, which can be used for e.g. Registration Approval, Time and Payment Specifications, Registration Cockpit - Statistic etc.

The Column can be setup for these functions:

Function ID	Description	Function
BreakGrossTime *	Break (Gross Time)	Gross Time between Breakstart and BreakStop
BreakTimePeriods *	Break (Time Periods)	Shows Break Periods
Clock-inClock-outGrossTime *	Clock-in & Clock-out (Gross Time	Gross Time between Clock-in and Clock-out
Clock-inClock-out Time Periods|Clock-in & Clock (Time Periods)|Shows Clock-in and Clock-out Periods | |Date |Date |Date, weekday, weeknumber etc. | |List - Absence |Absence List |Shows a "list" of the absence that day or period| |List - Assembly |Assembly List |Shows a "list" of assembly orders the employee has been working on| |List - IPCActivity |IPC Activity List |Shows a "list" of IPC activity the employee has been working on| |List - Job |Job List |Shows a "list" of Jobs(Projects) the employee has been working on| |List - Mileage |Mileage List |Shows a total amount of Miles or KM. e.g. "15 Miles" | |List - Production |Production List |Shows a "list" of Production order the employee has been working on. | |List - RegistrationAdd-on |Registration add-on List |Shows a "list" of used Add-ons. | |List - Service |Service List |Shows a "list" of Serviceordres the employee has been working on. | |List - Trigger |Job List |Shows a "list" of Jobs (Projects) the employee has been working on| |Paytype |Formula Pay Type |Shows the results of the formula |Sum-Hours |Sum Hours (Time Sheet) |Shows a total amount of registered hours* in the Timesheet.
TimeCounter	Formula Time Counters	Shows the results of the formula

Formula

*It is not possible to make a formula of this function.

Date
The date can be shown in different ways (Date, weekday, weeknumber etc.)
A formula kan e.g. contain: U<Week> <Weekday Text>
Read more here.

List Absence, IPC and Trigger
You can use: * |
With IPC List it deselects Triggers and Absence
With Trigger List it deselects "General" IPC and Absence.

List Mileage
If you only use Miles then the formula can be empty. It you create "Bridge" or others, then a filter can be used.

List Assembly, Production/Jobs(Project)/Service
Can filter on ordernumber.
You can use: * |

List Registration Add-on
Can filter on Add-ons.
You can use: * |

Paytype
[ ] = Per. day
{ } = Period (The Period can be specified on the Paytype - Statistics Period)
E.g. [Paytype_X] + [Paytype_Y]
E.g. {Paytype} el. {Paytype_X} + {Paytype_Y}
Find more inspiration for formula her

Time Counter
[ ] = Per. day
{ } = Period (On the TimeCounter)
E.g. [TimeCounter_X] + [TimeCounter_Y]
E.g. {TimeCounter} el. {TimeCounter_X} + {TimeCounter_Y}
Find more inspiration for formula her

Condition - Style

There can be created several conditions, which can change Style depending on the condition setup.
There are 3 opportunities for Conditions.

Clock-in/Clock-out & Break Periods This is compared with the number of zones.
E.g. ">2" can be coloured if the employee has clock-in/Clock-out multiple times.

Jobs (IPC, Absence, Prod. Jobs (Project) etc.)
This is compared with the amount on the list
E.g. ">2" can be coloured if the employee more that 2 lines.

TimeCounter
It is possible to use multiple Time Counters. It is also Possible to use an other Time Counter, then the one in the formula to be coloured.

E.g. If you want multiple "warnings", if the employee has more then X amount of hours in overtime.:

Formula: [Weekly hours]
Condition - Style 1: > 11,5 - Colour 1
Condition - Style 2: > 9,5 - Colour 2
Condition - Style 3: > 7,5 - Colour 3
The largest condition must be first, as "the search" stops when the condition has "met".

An other example is:
If you want a "warning" if the employee hasn't achieved hers/his std. hours.
The setup can be like this:

Formula: [Weekly hours]
Condition - Style 1: => 7,5 - Colour i green
Condition - Style 2: < 7,5 - Colour is red

Column ID
Description
Caption
Function ID
Show zero
Rounding Precision
Round type
Exists
NOT found
Report Alignment
Presentation Unit of Measure
Style1
Style2
Style3