> For the complete documentation index, see [llms.txt](https://docs.dynalogic.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.dynalogic.com/birds-jobmanager-product-overview/integrations-and-technical-reference/tables/statistics-column-6182308.md).

# Statistics Column

In *Statistic Column* it is able to make "your own" Columns, which can be used for e.g. [Registration Approval](https://docs.dynalogic.com/birds-jobmanager-product-overview/user-guide/general/registration-approval-6182765.md), *Time and Payment Specifications*, *Registration Cockpit - Statistic* etc.

(from version 01.40, it is possible to export/import the whole setup (all related tables) and formulas for Statistics Column)

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 Period&#x73;*\|Clock-in & Clock (Time Periods)\|Shows Clock-in and Clock-out Periods \| \|Date \|Date \|Date, weekday, weeknumber etc. \| \|Fieldvalue \|Fieldvalue \|Show selected field(s) from related tables. \| \|List - Work type \|Work type List \|Shows a "list" of work types used that day \| \|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 <a href="#formula" id="formula"></a>

\*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](https://learn.microsoft.com/en-us/dynamics-nav/format-property).

**Fieldvalue**\
Select field(s) from *Employee Stamp Sum* and/or related tables. Sample for showing *Resource No.* from the *Employee* table use the formula: `[[5200,38]]`. More fields can be added to same formula: `[[156,2]] - [[152,2]]`.\
Fields from the following table are supported:

* [JobManager Stamp Sum](https://docs.dynalogic.com/birds-jobmanager-product-overview/integrations-and-technical-reference/tables/employee-stamp-sum-6182621.md).
* JobManager Employee
* Employee
* Resource
* Resource Group

**List Absence, IPC and Trigger**\
You can use: \* |\
With *IPC List* it deselects [Triggers](https://docs.dynalogic.com/birds-jobmanager-product-overview/integrations-and-technical-reference/tables/time-schedule-6182441.md#field-20) 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](https://documentation.jmgapp.dk/en-us/T_6182551_35.htm))\
E.g. \[Paytype\_X] + \[Paytype\_Y]\
E.g. {Paytype} el. {Paytype\_X} + {Paytype\_Y}\
Find more inspiration for formula [her](https://docs.dynalogic.com/birds-jobmanager-product-overview/integrations-and-technical-reference/tables/calculation-warnings-errors-6182409.md#field-12)

**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](https://docs.dynalogic.com/birds-jobmanager-product-overview/integrations-and-technical-reference/tables/calculation-warnings-errors-6182409.md#field-12)

## Condition - Style <a href="#condition---style" id="condition---style"></a>

There can be created several conditions, which can change [Style](https://docs.dynalogic.com/birds-jobmanager-product-overview/integrations-and-technical-reference/tables/calculation-warnings-errors-6182409.md#field-41) 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\\

*The Pages and reports with Statistics is from version 01.41 now able to show totals. This is to be activated on each column setup*

| Topic                                     |
| ----------------------------------------- |
| [Column ID](#field-1)                     |
| [Description](#field-5)                   |
| [Caption](#field-6)                       |
| [Function ID](#field-10)                  |
| [Show zero](#field-20)                    |
| [Rounding Precision](#field-21)           |
| [Round type](#field-22)                   |
| [h:min](#field-23)                        |
| [Show Totals](#field-24)                  |
| [Exists](#field-31)                       |
| [NOT found](#field-32)                    |
| [Report Alignment](#field-80)             |
| [Presentation Unit of Measure](#field-90) |
| [Style1](#field-110)                      |
| [Style2](#field-120)                      |
| [Style3](#field-130)                      |

## See also

[Registration approval](https://docs.dynalogic.com/birds-jobmanager-product-overview/user-guide/general/registration-approval-6182765.md)

## Reference

[Column Function](https://documentation.jmgapp.dk/en-us/T_6182307.htm)\
[Statistics Column Set](https://docs.dynalogic.com/birds-jobmanager-product-overview/integrations-and-technical-reference/tables/statistics-column-set-6182309.md)\
[Statistics Column Set Relation](https://docs.dynalogic.com/birds-jobmanager-product-overview/integrations-and-technical-reference/tables/statistics-column-set-relation-6182310.md)

\
\\

<details>

<summary>Column ID</summary>

The Id of the Column.

</details>

<details>

<summary>Description</summary>

Description of the record.

</details>

<details>

<summary>Caption</summary>

This is the headline of the column.

</details>

<details>

<summary>Function ID</summary>

Contains the function of the column.

</details>

<details>

<summary>Show zero</summary>

Shows *zero* instead of a blank/empty field if the column's *result* is blank.

</details>

<details>

<summary>Rounding Precision</summary>

This parameter is used to set up *round off* scenarios for the entered value.

It will cause the system to round up, or round down to the nearest X.

E.g. if all *Qty* be rounded up to the nearest 0.25 - the setting in the two fields should be **0.25** and **Up**.

</details>

<details>

<summary>Round type</summary>

The *Round Type* kan be *Nearest*, *Up* or *Down*

</details>

<details>

<summary>h:min</summary>

Column setup is able to show the value as h:mm / hours:minutes

</details>

<details>

<summary>Show Totals</summary>

The pages and reports with Statistics Columns is now able to show totals. Should be activated on each Statistic Column with a mark in "Show totals".

</details>

<details>

<summary>Exists</summary>

A text/Message in the Column, that becomes active if the formula is *true*.

</details>

<details>

<summary>NOT found</summary>

A text/Message in the Column, that becomes active if the formula is *untrue*.

</details>

<details>

<summary>Report Alignment</summary>

The *results* kan be adjust to the right, left or centeret on **Reports** such as *Statistics on Time and Payment* and *Statistics Column*.

</details>

<details>

<summary>Presentation Unit of Measure</summary>

If a *Unit of Measure* is needed, this field must be filled out. The *Unit of Measue* comes after the *result* in the column.

E.g. Hour, day and Pcs.

</details>

<details>

<summary>Style1</summary>

The Column can be highlighted.

The options below are the same as those used widely in NAV/BC.

| ID              | Bold | Italic |  Color |
| --------------- | :--: | :----: | :----: |
| Standard        |      |        |  Black |
| StandardAccent  |      |        |  Blue  |
| Strong          |   X  |        |  Black |
| StrongAccent    |   X  |        |  Blue  |
| Attention       |      |    X   |   Red  |
| AttentionAccent |      |    X   |  Blue  |
| Favorable       |   X  |        |  Green |
| Unfavorable     |   X  |    X   |   Red  |
| Ambiguous       |      |        | Orange |
| Subordinate     |      |        |  Grey  |

</details>

<details>

<summary>Style2</summary>

The Column can be highlighted.

The options below are the same as those used widely in NAV/BC.

| ID              | Bold | Italic |  Color |
| --------------- | :--: | :----: | :----: |
| Standard        |      |        |  Black |
| StandardAccent  |      |        |  Blue  |
| Strong          |   X  |        |  Black |
| StrongAccent    |   X  |        |  Blue  |
| Attention       |      |    X   |   Red  |
| AttentionAccent |      |    X   |  Blue  |
| Favorable       |   X  |        |  Green |
| Unfavorable     |   X  |    X   |   Red  |
| Ambiguous       |      |        | Orange |
| Subordinate     |      |        |  Grey  |

</details>

<details>

<summary>Style3</summary>

The Column can be highlighted.

The options below are the same as those used widely in NAV/BC.

| ID              | Bold | Italic |  Color |
| --------------- | :--: | :----: | :----: |
| Standard        |      |        |  Black |
| StandardAccent  |      |        |  Blue  |
| Strong          |   X  |        |  Black |
| StrongAccent    |   X  |        |  Blue  |
| Attention       |      |    X   |   Red  |
| AttentionAccent |      |    X   |  Blue  |
| Favorable       |   X  |        |  Green |
| Unfavorable     |   X  |    X   |   Red  |
| Ambiguous       |      |        | Orange |
| Subordinate     |      |        |  Grey  |

</details>

{% hint style="warning" %}
Some links in the original help refer to unavailable topics. See [Legacy Source Gaps](https://docs.dynalogic.com/birds-jobmanager-product-overview/training-and-support/source-gaps.md) for details.
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.dynalogic.com/birds-jobmanager-product-overview/integrations-and-technical-reference/tables/statistics-column-6182308.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
