Asana units, metrics, and properties
Asana units, metrics, and properties
This page describes the available units, metrics, and properties when creating a chart for an Asana 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 Tasks and subtasks. |
|---|---|
Number field | Any of your Number custom fields can be used as unit in the charts. |
Formula field | Formula fields can be used as unit in the charts as long as its value is a number. Learn more. |
Select field | Select and Multi-select fields can be mapped as units. |
Time in state | Timing metrics (reaction, lead, cycle time) are based on the time spent on a section or a custom field value. |
Estimated time | Estimated time to complete a task or subtask. |
Actual time | Time logged to a time tracking field. 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 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) | Tasks by creation date (task creation date from the Asana API). |
Completed (within date range) | Tasks by Date completed. The last date & time when the item was completed (checked as done or moved to a state mapped as done) |
By Due date | Tasks by Due date (regardless of their status). Includes items that have the date within the specified date range. |
By Start date | Tasks by Start date (regardless of their status). Includes items that have the date within the specified date range. |
By [custom Date field] | Tasks 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 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 as columns in a Task list.
Actual time | Time logged to a time tracking field. |
|---|---|
Assignee | The assigned person |
Assignees | The assigned persons (if multiple) |
Completed on time | Was the task completed before the due date (true/false). |
Created by | The person who created the task. |
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 Asana project the item is currently in. |
Date completed | The last date & time when the task was completed (checked as done or moved to a state mapped as done). |
Date created | Task creation date (from the Asana API). |
Date updated | Last update date (from the Asana API) |
Due date | Due date of a task. |
Estimated time | Estimated time to complete a task. |
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 workflow settings.. 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) |
Portfolio | The Portfolio the task is currently assigned to. Portfolio is shown only if the user who did the authorization is the owner of the portfolio. |
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 task has been reopened (true/false) |
Section | The board section the task is currently in. If section is used as the workflow source, shows the current workflow state. |
Section (current) | The board section the task is currently in. If a task is moved to another section after its completion, this field shows the current section. |
Start date | Start date of a task, |
State (open/done) | Whether the task state is Open (Not started or In progress) or Done. |
Tag | Tags assigned to the task. |
Task ID | Unique identifier of the task (from the Asana API) |
Task name | Name of the task. |
Team | The team the task is assigned to. |
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 (Actual time) | Person who logged the 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 an Asana 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 Tasks and subtasks. |
|---|---|
Number field | Any of your Number custom fields can be used as unit in the charts. |
Formula field | Formula fields can be used as unit in the charts as long as its value is a number. Learn more. |
Select field | Select and Multi-select fields can be mapped as units. |
Time in state | Timing metrics (reaction, lead, cycle time) are based on the time spent on a section or a custom field value. |
Estimated time | Estimated time to complete a task or subtask. |
Actual time | Time logged to a time tracking field. 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 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) | Tasks by creation date (task creation date from the Asana API). |
Completed (within date range) | Tasks by Date completed. The last date & time when the item was completed (checked as done or moved to a state mapped as done) |
By Due date | Tasks by Due date (regardless of their status). Includes items that have the date within the specified date range. |
By Start date | Tasks by Start date (regardless of their status). Includes items that have the date within the specified date range. |
By [custom Date field] | Tasks 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 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 as columns in a Task list.
Actual time | Time logged to a time tracking field. |
|---|---|
Assignee | The assigned person |
Assignees | The assigned persons (if multiple) |
Completed on time | Was the task completed before the due date (true/false). |
Created by | The person who created the task. |
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 Asana project the item is currently in. |
Date completed | The last date & time when the task was completed (checked as done or moved to a state mapped as done). |
Date created | Task creation date (from the Asana API). |
Date updated | Last update date (from the Asana API) |
Due date | Due date of a task. |
Estimated time | Estimated time to complete a task. |
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 workflow settings.. 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) |
Portfolio | The Portfolio the task is currently assigned to. Portfolio is shown only if the user who did the authorization is the owner of the portfolio. |
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 task has been reopened (true/false) |
Section | The board section the task is currently in. If section is used as the workflow source, shows the current workflow state. |
Section (current) | The board section the task is currently in. If a task is moved to another section after its completion, this field shows the current section. |
Start date | Start date of a task, |
State (open/done) | Whether the task state is Open (Not started or In progress) or Done. |
Tag | Tags assigned to the task. |
Task ID | Unique identifier of the task (from the Asana API) |
Task name | Name of the task. |
Team | The team the task is assigned to. |
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 (Actual time) | Person who logged the 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 an Asana 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 Tasks and subtasks. |
|---|---|
Number field | Any of your Number custom fields can be used as unit in the charts. |
Formula field | Formula fields can be used as unit in the charts as long as its value is a number. Learn more. |
Select field | Select and Multi-select fields can be mapped as units. |
Time in state | Timing metrics (reaction, lead, cycle time) are based on the time spent on a section or a custom field value. |
Estimated time | Estimated time to complete a task or subtask. |
Actual time | Time logged to a time tracking field. 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 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) | Tasks by creation date (task creation date from the Asana API). |
Completed (within date range) | Tasks by Date completed. The last date & time when the item was completed (checked as done or moved to a state mapped as done) |
By Due date | Tasks by Due date (regardless of their status). Includes items that have the date within the specified date range. |
By Start date | Tasks by Start date (regardless of their status). Includes items that have the date within the specified date range. |
By [custom Date field] | Tasks 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 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 as columns in a Task list.
Actual time | Time logged to a time tracking field. |
|---|---|
Assignee | The assigned person |
Assignees | The assigned persons (if multiple) |
Completed on time | Was the task completed before the due date (true/false). |
Created by | The person who created the task. |
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 Asana project the item is currently in. |
Date completed | The last date & time when the task was completed (checked as done or moved to a state mapped as done). |
Date created | Task creation date (from the Asana API). |
Date updated | Last update date (from the Asana API) |
Due date | Due date of a task. |
Estimated time | Estimated time to complete a task. |
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 workflow settings.. 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) |
Portfolio | The Portfolio the task is currently assigned to. Portfolio is shown only if the user who did the authorization is the owner of the portfolio. |
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 task has been reopened (true/false) |
Section | The board section the task is currently in. If section is used as the workflow source, shows the current workflow state. |
Section (current) | The board section the task is currently in. If a task is moved to another section after its completion, this field shows the current section. |
Start date | Start date of a task, |
State (open/done) | Whether the task state is Open (Not started or In progress) or Done. |
Tag | Tags assigned to the task. |
Task ID | Unique identifier of the task (from the Asana API) |
Task name | Name of the task. |
Team | The team the task is assigned to. |
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 (Actual time) | Person who logged the 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. |