monday.com units, metrics, and properties
monday.com units, metrics, and properties
This page describes the available units, metrics, and properties when creating a chart for a monday.com data source. See also these related guides:
Units
Units are the numbers shown in the charts. Unit can be any of these:
Item | The default unit is Item i.e. a chart displays the count of items and subitems. |
|---|---|
Number column | Any of your Number columns can be used as unit in the charts. |
Formula column | Most Formula columns can be used as unit in the charts. See the exceptions. |
Dropdown column | Dropdown columns can be mapped as units. |
Time in state | Timing metrics (reaction, lead, cycle time) are calculated for the selected Status column. |
Logged time | Time logged to any of your time tracking columns. The date range refers to when the time was logged. |
All units share these characteristics:
They can be filtered by any property of an item
They can be summarized as sum, average, or median
They can be formatted as numbers, monetary units, or time units
Metrics
Metrics are the calculations performed on the selected unit.
Total | Shows the total amount of the selected unit in the selected data sources. |
|---|---|
Not started | Work not started according to the selected Status column. |
Not started & In progress | Incomplete work according to the selected Status column. |
In progress | Work in progress according to the selected Status column. |
Created (within date range) | Items by creation date (item creation date created_at from the Monday API). |
Completed (within date range) | Items by Date completed. The last date & time when the item was marked as done (the selected Status column was changed to a status mapped as done) |
By Due date | Items by Due date (regardless of their status). Includes items that have the date within the specified date range. You can have any of your Date or Timeline columns mapped as Due date. |
By Start date | Items by Start date (regardless of their status). Includes items that have the date within the specified date range. You can have any of your Date or Timeline columns mapped as Start date. |
By [name of Date column] | Items by a Date column (regardless of their status). Includes items that have the date within the specified date range. |
Reaction time (avg, completed items) | Time before the work was started. The average time spent in the states mapped as Not started in the workflow settings. |
Reaction time (sum, completed items) | Time before the work was started. The sum of time spent in the states mapped as Not started in the workflow settings. |
Cycle time (avg, completed items) | Time from start to completion. The average time spent in the states mapped as In progress in the workflow settings. |
Cycle time (sum, completed items) | Time from start to completion. The sum of time spent in the states mapped as In progress in the workflow settings. |
Lead time (avg, completed items) | Lead time (avg) = (Reaction time + Cycle time) (avg) |
Lead time (sum, completed items) | Lead time (sum) = (Reaction time + Cycle time) (sum) |
Time in state (avg, completed items) | Time spent in specific workflow states. Use the filter to select the states. |
Time in state (sum, completed items) | Time spent in specific workflow states. Use the filter to select the states. |
Item properties
Item properties that can be displayed in a Task list.
Assignee | The assigned person |
|---|---|
Assignees | The assigned persons (if multiple) |
Completed on time | Was the item completed before the due date (true/false). You can have any of your Date or Timeline columns mapped as Due date. |
Created by | The person who created the item |
Cycle time | Time from start to completion. The time spent in the states mapped as In progress in the workflow settings. |
Cycle time (working hours) | Time from start to completion. The time spent in the states mapped as In progress in the workflow settings.Time is calculated only within the set working days and hours. |
Data source | The Monday board the item is currently in. |
Date completed | The last date & time when the item was marked as done (the selected Status column was changed to a status mapped as done) |
Date created | Item creation date (created_at from the Monday API). |
Date updated | Last update date (updated_at from the Monday API) |
Due date | Item Due date. You can have any of your Date or Timeline columns mapped as Due date. |
Group | The group in the board the item is currently in. |
Item ID | Unique identifier of the item by monday.com |
Issue name | The name of the item. |
Item type | Either Item or Subitem |
Lead time | Reaction time + Cycle time |
Lead time (working hours) | Reaction time + Cycle time. Time is calculated only within the set working days and hours. |
Mapped state | Mapped workflow state according to the selected Status column. Either Not started, In progress, or Done. |
Moved to mapped state | The time when the item was moved to its current mapped workflow state. |
Moved to workflow state | The time when the item was moved to its current workflow state. |
Parent | Parent item of the item (if any) |
Reaction time | Time before the work was started. The time spent in the states mapped as Not started in the workflow settings. |
Reaction time (working hours) | Time before the work was started. The time spent in the states mapped as Not started in the workflow settings. Time is calculated only within the set working days and hours. |
Reopened | Whether the item has been reopened (true/false) |
Start date | Item Start date. You can have any of your Date or Timeline columns mapped as Start date. |
State (open/done) | Whether the item state is Open (Not started or In progress) or Done. |
Time in progress | Time in progress so far. The time spent in the states mapped as In progress in the workflow settings. |
Time in progress (working hours) | Time in progress so far. The time spent in the states mapped as In progress in the workflow settings. Time is calculated only within the set working days and hours. |
Time in workflow state | How long the item has been in its current workflow state according to the workflow settings. |
Time logged by | Person who logged hours into the time tracking field. |
Timings | How long the item has been in each workflow state according to the workflow settings. |
Workflow state | Workflow state according to the workflow settings. |
This page describes the available units, metrics, and properties when creating a chart for a monday.com data source. See also these related guides:
Units
Units are the numbers shown in the charts. Unit can be any of these:
Item | The default unit is Item i.e. a chart displays the count of items and subitems. |
|---|---|
Number column | Any of your Number columns can be used as unit in the charts. |
Formula column | Most Formula columns can be used as unit in the charts. See the exceptions. |
Dropdown column | Dropdown columns can be mapped as units. |
Time in state | Timing metrics (reaction, lead, cycle time) are calculated for the selected Status column. |
Logged time | Time logged to any of your time tracking columns. The date range refers to when the time was logged. |
All units share these characteristics:
They can be filtered by any property of an item
They can be summarized as sum, average, or median
They can be formatted as numbers, monetary units, or time units
Metrics
Metrics are the calculations performed on the selected unit.
Total | Shows the total amount of the selected unit in the selected data sources. |
|---|---|
Not started | Work not started according to the selected Status column. |
Not started & In progress | Incomplete work according to the selected Status column. |
In progress | Work in progress according to the selected Status column. |
Created (within date range) | Items by creation date (item creation date created_at from the Monday API). |
Completed (within date range) | Items by Date completed. The last date & time when the item was marked as done (the selected Status column was changed to a status mapped as done) |
By Due date | Items by Due date (regardless of their status). Includes items that have the date within the specified date range. You can have any of your Date or Timeline columns mapped as Due date. |
By Start date | Items by Start date (regardless of their status). Includes items that have the date within the specified date range. You can have any of your Date or Timeline columns mapped as Start date. |
By [name of Date column] | Items by a Date column (regardless of their status). Includes items that have the date within the specified date range. |
Reaction time (avg, completed items) | Time before the work was started. The average time spent in the states mapped as Not started in the workflow settings. |
Reaction time (sum, completed items) | Time before the work was started. The sum of time spent in the states mapped as Not started in the workflow settings. |
Cycle time (avg, completed items) | Time from start to completion. The average time spent in the states mapped as In progress in the workflow settings. |
Cycle time (sum, completed items) | Time from start to completion. The sum of time spent in the states mapped as In progress in the workflow settings. |
Lead time (avg, completed items) | Lead time (avg) = (Reaction time + Cycle time) (avg) |
Lead time (sum, completed items) | Lead time (sum) = (Reaction time + Cycle time) (sum) |
Time in state (avg, completed items) | Time spent in specific workflow states. Use the filter to select the states. |
Time in state (sum, completed items) | Time spent in specific workflow states. Use the filter to select the states. |
Item properties
Item properties that can be displayed in a Task list.
Assignee | The assigned person |
|---|---|
Assignees | The assigned persons (if multiple) |
Completed on time | Was the item completed before the due date (true/false). You can have any of your Date or Timeline columns mapped as Due date. |
Created by | The person who created the item |
Cycle time | Time from start to completion. The time spent in the states mapped as In progress in the workflow settings. |
Cycle time (working hours) | Time from start to completion. The time spent in the states mapped as In progress in the workflow settings.Time is calculated only within the set working days and hours. |
Data source | The Monday board the item is currently in. |
Date completed | The last date & time when the item was marked as done (the selected Status column was changed to a status mapped as done) |
Date created | Item creation date (created_at from the Monday API). |
Date updated | Last update date (updated_at from the Monday API) |
Due date | Item Due date. You can have any of your Date or Timeline columns mapped as Due date. |
Group | The group in the board the item is currently in. |
Item ID | Unique identifier of the item by monday.com |
Issue name | The name of the item. |
Item type | Either Item or Subitem |
Lead time | Reaction time + Cycle time |
Lead time (working hours) | Reaction time + Cycle time. Time is calculated only within the set working days and hours. |
Mapped state | Mapped workflow state according to the selected Status column. Either Not started, In progress, or Done. |
Moved to mapped state | The time when the item was moved to its current mapped workflow state. |
Moved to workflow state | The time when the item was moved to its current workflow state. |
Parent | Parent item of the item (if any) |
Reaction time | Time before the work was started. The time spent in the states mapped as Not started in the workflow settings. |
Reaction time (working hours) | Time before the work was started. The time spent in the states mapped as Not started in the workflow settings. Time is calculated only within the set working days and hours. |
Reopened | Whether the item has been reopened (true/false) |
Start date | Item Start date. You can have any of your Date or Timeline columns mapped as Start date. |
State (open/done) | Whether the item state is Open (Not started or In progress) or Done. |
Time in progress | Time in progress so far. The time spent in the states mapped as In progress in the workflow settings. |
Time in progress (working hours) | Time in progress so far. The time spent in the states mapped as In progress in the workflow settings. Time is calculated only within the set working days and hours. |
Time in workflow state | How long the item has been in its current workflow state according to the workflow settings. |
Time logged by | Person who logged hours into the time tracking field. |
Timings | How long the item has been in each workflow state according to the workflow settings. |
Workflow state | Workflow state according to the workflow settings. |
This page describes the available units, metrics, and properties when creating a chart for a monday.com data source. See also these related guides:
Units
Units are the numbers shown in the charts. Unit can be any of these:
Item | The default unit is Item i.e. a chart displays the count of items and subitems. |
|---|---|
Number column | Any of your Number columns can be used as unit in the charts. |
Formula column | Most Formula columns can be used as unit in the charts. See the exceptions. |
Dropdown column | Dropdown columns can be mapped as units. |
Time in state | Timing metrics (reaction, lead, cycle time) are calculated for the selected Status column. |
Logged time | Time logged to any of your time tracking columns. The date range refers to when the time was logged. |
All units share these characteristics:
They can be filtered by any property of an item
They can be summarized as sum, average, or median
They can be formatted as numbers, monetary units, or time units
Metrics
Metrics are the calculations performed on the selected unit.
Total | Shows the total amount of the selected unit in the selected data sources. |
|---|---|
Not started | Work not started according to the selected Status column. |
Not started & In progress | Incomplete work according to the selected Status column. |
In progress | Work in progress according to the selected Status column. |
Created (within date range) | Items by creation date (item creation date created_at from the Monday API). |
Completed (within date range) | Items by Date completed. The last date & time when the item was marked as done (the selected Status column was changed to a status mapped as done) |
By Due date | Items by Due date (regardless of their status). Includes items that have the date within the specified date range. You can have any of your Date or Timeline columns mapped as Due date. |
By Start date | Items by Start date (regardless of their status). Includes items that have the date within the specified date range. You can have any of your Date or Timeline columns mapped as Start date. |
By [name of Date column] | Items by a Date column (regardless of their status). Includes items that have the date within the specified date range. |
Reaction time (avg, completed items) | Time before the work was started. The average time spent in the states mapped as Not started in the workflow settings. |
Reaction time (sum, completed items) | Time before the work was started. The sum of time spent in the states mapped as Not started in the workflow settings. |
Cycle time (avg, completed items) | Time from start to completion. The average time spent in the states mapped as In progress in the workflow settings. |
Cycle time (sum, completed items) | Time from start to completion. The sum of time spent in the states mapped as In progress in the workflow settings. |
Lead time (avg, completed items) | Lead time (avg) = (Reaction time + Cycle time) (avg) |
Lead time (sum, completed items) | Lead time (sum) = (Reaction time + Cycle time) (sum) |
Time in state (avg, completed items) | Time spent in specific workflow states. Use the filter to select the states. |
Time in state (sum, completed items) | Time spent in specific workflow states. Use the filter to select the states. |
Item properties
Item properties that can be displayed in a Task list.
Assignee | The assigned person |
|---|---|
Assignees | The assigned persons (if multiple) |
Completed on time | Was the item completed before the due date (true/false). You can have any of your Date or Timeline columns mapped as Due date. |
Created by | The person who created the item |
Cycle time | Time from start to completion. The time spent in the states mapped as In progress in the workflow settings. |
Cycle time (working hours) | Time from start to completion. The time spent in the states mapped as In progress in the workflow settings.Time is calculated only within the set working days and hours. |
Data source | The Monday board the item is currently in. |
Date completed | The last date & time when the item was marked as done (the selected Status column was changed to a status mapped as done) |
Date created | Item creation date (created_at from the Monday API). |
Date updated | Last update date (updated_at from the Monday API) |
Due date | Item Due date. You can have any of your Date or Timeline columns mapped as Due date. |
Group | The group in the board the item is currently in. |
Item ID | Unique identifier of the item by monday.com |
Issue name | The name of the item. |
Item type | Either Item or Subitem |
Lead time | Reaction time + Cycle time |
Lead time (working hours) | Reaction time + Cycle time. Time is calculated only within the set working days and hours. |
Mapped state | Mapped workflow state according to the selected Status column. Either Not started, In progress, or Done. |
Moved to mapped state | The time when the item was moved to its current mapped workflow state. |
Moved to workflow state | The time when the item was moved to its current workflow state. |
Parent | Parent item of the item (if any) |
Reaction time | Time before the work was started. The time spent in the states mapped as Not started in the workflow settings. |
Reaction time (working hours) | Time before the work was started. The time spent in the states mapped as Not started in the workflow settings. Time is calculated only within the set working days and hours. |
Reopened | Whether the item has been reopened (true/false) |
Start date | Item Start date. You can have any of your Date or Timeline columns mapped as Start date. |
State (open/done) | Whether the item state is Open (Not started or In progress) or Done. |
Time in progress | Time in progress so far. The time spent in the states mapped as In progress in the workflow settings. |
Time in progress (working hours) | Time in progress so far. The time spent in the states mapped as In progress in the workflow settings. Time is calculated only within the set working days and hours. |
Time in workflow state | How long the item has been in its current workflow state according to the workflow settings. |
Time logged by | Person who logged hours into the time tracking field. |
Timings | How long the item has been in each workflow state according to the workflow settings. |
Workflow state | Workflow state according to the workflow settings. |