Trello units, metrics, and properties
Trello units, metrics, and properties
This page describes the available units, metrics, and properties when creating a chart for a Trello data source. See also these related guides:
Units
Units are the numbers shown in the charts. Unit can be any of these:
Task | The default unit is Task i.e. a chart displays the count of cards. |
|---|---|
Card size | Work estimate from the Card Size Power-Up. |
Number field | Any of your Number custom fields can be used as unit in the charts. |
Dropdown field | Dropdown fields can be mapped as units. |
Time in state | Timing metrics (reaction, lead, cycle time) are based on the time spent on a list. |
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 workflow settings. |
Not started & In progress | Incomplete work according to the workflow settings. |
In progress | Work in progress according to the workflow settings. |
Created (within date range) | Cards by creation date (card creation date from the Trello API). |
Completed (within date range) | Cards by Date completed. The last date & time when the item was completed (moved to a list mapped as done) |
By Due date | Cards by Due date (regardless of their status). Includes items that have the date within the specified date range. |
By Start date | Cards by Start date (regardless of their status). Includes items that have the date within the specified date range. |
By [custom Date field] | Cards by a custom Date field (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 lists 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 lists mapped as Not started in the workflow settings. |
Cycle time (avg, completed items) | Time from start to completion. The average time spent in the lists mapped as In progress in the workflow settings. |
Cycle time (sum, completed items) | Time from start to completion. The sum of time spent in lists 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 a list. Use the filter to select the lists. |
Time in state (sum, completed items) | Time spent in a list. Use the filter to select the lists. |
Item properties
Item properties that can be displayed as columns in a Task list.
Assignee | The assigned person |
|---|---|
Assignees | The assigned persons (if multiple) |
Blocked | Whether a card is blocked by some other card. Requires the Card Dependencies Power-Up. |
Card priority | The priority of the card. Requires the Card Priority Power-Up. |
Card size | Estimated effort to complete the task. Requires the Card Size Power-Up. |
Card size remaining | Remaining effort to complete the task. Requires the Card Size Power-Up. |
Card size spent | Effort spent so far to complete the task. Requires the Card Size Power-Up. |
Card type | Either task or epic. |
Completed on time | Was the task completed before the due date (true/false). |
Created by | The person who created the card. |
Cycle time | Time from start to completion. The time spent in the lists mapped as In progress in the workflow settings. |
Cycle time (working hours) | Time from start to completion. The time spent in the lists mapped as In progress in the workflow settings. Time is calculated only within the set working days and hours. |
Data source | The Trello board the card is currently in. |
Date completed | The last date & time when the card was completed (moved to a list mapped as done). |
Date created | Card creation date (from the Trello API). |
Date updated | Last update date (from the Trello API) |
Due date | Due date of the card. |
Epic | The epic the card is assigned to. Requires the Epic Cards Power-Up. |
Label | Assigned labels. |
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. |
List | The Trello list the card is current in. |
Mapped state | Mapped workflow state according to the workflow settings. Either Not started, In progress, or Done. |
Moved to mapped state | The time when the card was moved to its current mapped workflow state. |
Moved to workflow state | The time when the card was moved to its current list. |
Rank | Card's position in a board in relation to other cards. |
Reaction time | Time before the work was started. The time spent in the lists mapped as Not started in the workflow settings. |
Reaction time (working hours) | Time before the work was started. The time spent in the lists mapped as Not started in the workflow settings. Time is calculated only within the set working days and hours. |
Reopened | Whether the card has been reopened (true/false) |
Start date | Start date of a card, |
State (open/done) | Whether the card state is Open (Not started or In progress) or Done. |
Task ID | Unique identifier of the card (from the Trello API) |
Task name | Name of the card. |
Time in progress | Time in progress so far. The time spent in the lists mapped as In progress in the workflow settings. |
Time in progress (working hours) | Time in progress so far. The time spent in the lists 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 card has been in its current list according to the workflow settings. |
Timings | How long the card has stayed in each list. |
Workflow state | Current list according to the workflow settings. |
This page describes the available units, metrics, and properties when creating a chart for a Trello data source. See also these related guides:
Units
Units are the numbers shown in the charts. Unit can be any of these:
Task | The default unit is Task i.e. a chart displays the count of cards. |
|---|---|
Card size | Work estimate from the Card Size Power-Up. |
Number field | Any of your Number custom fields can be used as unit in the charts. |
Dropdown field | Dropdown fields can be mapped as units. |
Time in state | Timing metrics (reaction, lead, cycle time) are based on the time spent on a list. |
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 workflow settings. |
Not started & In progress | Incomplete work according to the workflow settings. |
In progress | Work in progress according to the workflow settings. |
Created (within date range) | Cards by creation date (card creation date from the Trello API). |
Completed (within date range) | Cards by Date completed. The last date & time when the item was completed (moved to a list mapped as done) |
By Due date | Cards by Due date (regardless of their status). Includes items that have the date within the specified date range. |
By Start date | Cards by Start date (regardless of their status). Includes items that have the date within the specified date range. |
By [custom Date field] | Cards by a custom Date field (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 lists 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 lists mapped as Not started in the workflow settings. |
Cycle time (avg, completed items) | Time from start to completion. The average time spent in the lists mapped as In progress in the workflow settings. |
Cycle time (sum, completed items) | Time from start to completion. The sum of time spent in lists 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 a list. Use the filter to select the lists. |
Time in state (sum, completed items) | Time spent in a list. Use the filter to select the lists. |
Item properties
Item properties that can be displayed as columns in a Task list.
Assignee | The assigned person |
|---|---|
Assignees | The assigned persons (if multiple) |
Blocked | Whether a card is blocked by some other card. Requires the Card Dependencies Power-Up. |
Card priority | The priority of the card. Requires the Card Priority Power-Up. |
Card size | Estimated effort to complete the task. Requires the Card Size Power-Up. |
Card size remaining | Remaining effort to complete the task. Requires the Card Size Power-Up. |
Card size spent | Effort spent so far to complete the task. Requires the Card Size Power-Up. |
Card type | Either task or epic. |
Completed on time | Was the task completed before the due date (true/false). |
Created by | The person who created the card. |
Cycle time | Time from start to completion. The time spent in the lists mapped as In progress in the workflow settings. |
Cycle time (working hours) | Time from start to completion. The time spent in the lists mapped as In progress in the workflow settings. Time is calculated only within the set working days and hours. |
Data source | The Trello board the card is currently in. |
Date completed | The last date & time when the card was completed (moved to a list mapped as done). |
Date created | Card creation date (from the Trello API). |
Date updated | Last update date (from the Trello API) |
Due date | Due date of the card. |
Epic | The epic the card is assigned to. Requires the Epic Cards Power-Up. |
Label | Assigned labels. |
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. |
List | The Trello list the card is current in. |
Mapped state | Mapped workflow state according to the workflow settings. Either Not started, In progress, or Done. |
Moved to mapped state | The time when the card was moved to its current mapped workflow state. |
Moved to workflow state | The time when the card was moved to its current list. |
Rank | Card's position in a board in relation to other cards. |
Reaction time | Time before the work was started. The time spent in the lists mapped as Not started in the workflow settings. |
Reaction time (working hours) | Time before the work was started. The time spent in the lists mapped as Not started in the workflow settings. Time is calculated only within the set working days and hours. |
Reopened | Whether the card has been reopened (true/false) |
Start date | Start date of a card, |
State (open/done) | Whether the card state is Open (Not started or In progress) or Done. |
Task ID | Unique identifier of the card (from the Trello API) |
Task name | Name of the card. |
Time in progress | Time in progress so far. The time spent in the lists mapped as In progress in the workflow settings. |
Time in progress (working hours) | Time in progress so far. The time spent in the lists 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 card has been in its current list according to the workflow settings. |
Timings | How long the card has stayed in each list. |
Workflow state | Current list according to the workflow settings. |
This page describes the available units, metrics, and properties when creating a chart for a Trello data source. See also these related guides:
Units
Units are the numbers shown in the charts. Unit can be any of these:
Task | The default unit is Task i.e. a chart displays the count of cards. |
|---|---|
Card size | Work estimate from the Card Size Power-Up. |
Number field | Any of your Number custom fields can be used as unit in the charts. |
Dropdown field | Dropdown fields can be mapped as units. |
Time in state | Timing metrics (reaction, lead, cycle time) are based on the time spent on a list. |
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 workflow settings. |
Not started & In progress | Incomplete work according to the workflow settings. |
In progress | Work in progress according to the workflow settings. |
Created (within date range) | Cards by creation date (card creation date from the Trello API). |
Completed (within date range) | Cards by Date completed. The last date & time when the item was completed (moved to a list mapped as done) |
By Due date | Cards by Due date (regardless of their status). Includes items that have the date within the specified date range. |
By Start date | Cards by Start date (regardless of their status). Includes items that have the date within the specified date range. |
By [custom Date field] | Cards by a custom Date field (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 lists 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 lists mapped as Not started in the workflow settings. |
Cycle time (avg, completed items) | Time from start to completion. The average time spent in the lists mapped as In progress in the workflow settings. |
Cycle time (sum, completed items) | Time from start to completion. The sum of time spent in lists 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 a list. Use the filter to select the lists. |
Time in state (sum, completed items) | Time spent in a list. Use the filter to select the lists. |
Item properties
Item properties that can be displayed as columns in a Task list.
Assignee | The assigned person |
|---|---|
Assignees | The assigned persons (if multiple) |
Blocked | Whether a card is blocked by some other card. Requires the Card Dependencies Power-Up. |
Card priority | The priority of the card. Requires the Card Priority Power-Up. |
Card size | Estimated effort to complete the task. Requires the Card Size Power-Up. |
Card size remaining | Remaining effort to complete the task. Requires the Card Size Power-Up. |
Card size spent | Effort spent so far to complete the task. Requires the Card Size Power-Up. |
Card type | Either task or epic. |
Completed on time | Was the task completed before the due date (true/false). |
Created by | The person who created the card. |
Cycle time | Time from start to completion. The time spent in the lists mapped as In progress in the workflow settings. |
Cycle time (working hours) | Time from start to completion. The time spent in the lists mapped as In progress in the workflow settings. Time is calculated only within the set working days and hours. |
Data source | The Trello board the card is currently in. |
Date completed | The last date & time when the card was completed (moved to a list mapped as done). |
Date created | Card creation date (from the Trello API). |
Date updated | Last update date (from the Trello API) |
Due date | Due date of the card. |
Epic | The epic the card is assigned to. Requires the Epic Cards Power-Up. |
Label | Assigned labels. |
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. |
List | The Trello list the card is current in. |
Mapped state | Mapped workflow state according to the workflow settings. Either Not started, In progress, or Done. |
Moved to mapped state | The time when the card was moved to its current mapped workflow state. |
Moved to workflow state | The time when the card was moved to its current list. |
Rank | Card's position in a board in relation to other cards. |
Reaction time | Time before the work was started. The time spent in the lists mapped as Not started in the workflow settings. |
Reaction time (working hours) | Time before the work was started. The time spent in the lists mapped as Not started in the workflow settings. Time is calculated only within the set working days and hours. |
Reopened | Whether the card has been reopened (true/false) |
Start date | Start date of a card, |
State (open/done) | Whether the card state is Open (Not started or In progress) or Done. |
Task ID | Unique identifier of the card (from the Trello API) |
Task name | Name of the card. |
Time in progress | Time in progress so far. The time spent in the lists mapped as In progress in the workflow settings. |
Time in progress (working hours) | Time in progress so far. The time spent in the lists 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 card has been in its current list according to the workflow settings. |
Timings | How long the card has stayed in each list. |
Workflow state | Current list according to the workflow settings. |