This page describes the available units, metrics, and properties when creating a chart for an Asana data source.
See also these related guides
Chart editor guide
Creating charts using ClickUp custom fields
Screenful Knowledge base
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. |
|---|---|
Estimates | ClickUp's default estimation field to describe the size of a task. |
Number field | Any of your Number custom fields can be used as a unit in the charts. |
Formula field | Formula fields can be used as a unit in the charts as long as the value is a number. |
Dropdown field | Dropdown fields are not available as a unit by default, but they can be mapped as units. |
Time in state | Timing metrics (reaction, lead, cycle time). These are calculated for all tasks and subtasks. Notice: We have limited support for the timing metrics in ClickUp data sources due to the limitation in the ClickUp API. |
Time estimate | Estimated time to complete a task or subtask. |
Time spent | 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 Date closed | Tasks by Date closed. Includes items with the date within the specified date range. |
By Date done | Tasks by Date done. Includes items with the date within the specified date range. |
By Due date | Tasks by Due date. Includes items with the date within the specified date range. |
By Start date | Tasks by Start date. Includes items with the date within the specified date range. |
By [custom Date field] | Tasks by a custom Date field. Includes items with 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. Notice: We have limited support for the timing metrics in ClickUp data sources due to the limitation in the ClickUp API. |
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. Notice: We have limited support for the timing metrics in ClickUp data sources due to the limitation in the ClickUp API. |
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. Notice: We have limited support for the timing metrics in ClickUp data sources due to the limitation in the ClickUp API. |
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. Notice: We have limited support for the timing metrics in ClickUp data sources due to the limitation in the ClickUp API. |
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. Notice: We have limited support for the timing metrics in ClickUp data sources due to the limitation in the ClickUp API. |
Time in state (sum, completed items) | Time spent in specific workflow states. Use the filter to select the states. Notice: We have limited support for the timing metrics in ClickUp data sources due to the limitation in the ClickUp API. |
Item properties
Item properties that can be displayed as columns in a Task list.
Assignee | The assigned person |
|---|---|
Assignees | The assigned persons (if multiple) |
ClickUp status | ClickUp workflow field. It is used to indicate whether a task is not started, in progress, or completed. |
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 closed | Task closed date (from the ClickUp API). |
Date completed | The last date & time when the task was completed (moved to a state mapped as done). |
Date created | Task creation date (from the ClickUp API). |
Date done | Task done date (from the ClickUp API). |
Date updated | Last update date (from the Asana API) |
Due date | Due date of a task. |
Estimate | Estimated effort to complete a task. |
Folder | The folder where a task is assigned |
Item type | Either Task or Subtask. |
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 list where a task is assigned |
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 (task) of the item (subtask) |
Priority | The priority of a task |
Rank | A non-readable character sequence that can be used for ordering the tasks. |
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) |
Start date | Start date of a task |
State (open/done) | Whether the task state is Open (Not started or In progress) or Done. |
Tags | Tags assigned to the task. |
Task ID | Unique identifier of the task (from the Asana API) |
Task name | Name of the task. |
Task type | Custom task type, such as Bug, Campaign, Epic, etc. |
Time estimate | Estimated time to complete a task. |
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. Notice: We have limited support for the timing metrics in ClickUp data sources due to the limitation in the ClickUp API. |
Time logged by (Time spent) | The person who logged the hours into the time tracking field. |
Time spent | Time logged to a 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. |
Learn more
FAQ
Common questions
A data source is a Space. The pricing is based on the number of spaces you explicitly import to Screenful, not the total number of spaces in ClickUp. One data source can contain any number of lists and folders. You can compare plans on the pricing page.
You can import data sources from all the tools we support in the same Screenful account. Learn more about managing data sources.
A data source is a Space. The pricing is based on the number of spaces you explicitly import to Screenful, not the total number of spaces in ClickUp. One data source can contain any number of lists and folders. You can compare plans on the pricing page.
You can import data sources from all the tools we support in the same Screenful account. Learn more about managing data sources.
You can manage the subscription in the billing settings. The location of the billing settings depends on the product you are subscribed to. You can learn more by following the instructions in this guide.
You can manage the subscription in the billing settings. The location of the billing settings depends on the product you are subscribed to. You can learn more by following the instructions in this guide.
We do not make changes to your data. We only read it via the API of your tool. Screenful is only for reporting and analytics. It does not update any data within your tools.
We do not make changes to your data. We only read it via the API of your tool. Screenful is only for reporting and analytics. It does not update any data within your tools.
All data sources are synced automatically once per hour. Changing settings or configuration will trigger additional sync so your data is at most one hour old. You can sync data manually at any time in the sync settings.
All data sources are synced automatically once per hour. Changing settings or configuration will trigger additional sync so your data is at most one hour old. You can sync data manually at any time in the sync settings.
Yes, you can create charts with a prompt and ask questions about a chart by using the Screenful AI Assistant. The assistant combines the leading LLMs with advanced multidimensional data analytics to help you understand and interpret your data.
Yes, you can create charts with a prompt and ask questions about a chart by using the Screenful AI Assistant. The assistant combines the leading LLMs with advanced multidimensional data analytics to help you understand and interpret your data.
What is the difference between these metrics?
Reaction time = time before the work was started
Cycle time = time from start to completion
Lead time = Reaction time + Cycle time
Timing metrics explained: Lead time vs Cycle time
How is the reaction time calculated?
Reaction time starts running when a task is moved into a state that is mapped to the "Not started" in the workflow mapping. The reaction time stops when the task is moved out from that state. If the task is never placed into a state that is mapped to the “Not started” workflow state, then the reaction time is zero.
What if tasks skip lists/columns, or there is no sequential workflow?
The timing information is based on how long items stay in the workflow states that are mapped to "In progress" in the workflow mapping. There is no need for sequential progress, and it is totally fine if tasks skip some of the workflow steps.
What if a task is moved from the “not started” state directly to “done” without going through any of the “in progress” states?
In that case, the cycle time will be zero.
How does the cycle time work if a task is moved into "in progress" and then back to "not started yet"? Similarly, what happens if a card is archived while it's in progress?
Cycle time is calculated only for completed tasks, so in both of those cases, cycle time would be undefined.
If a task is moved from "in progress" to "done", but then back to "in progress" again for additional work would this time be added to the cycle time?
Cycle time is counted only when the task is in progress, so the time spent in the "done" state is not included in the calculation.
When is a task created? Does the clock start when a task is created or when it is put in the "next" state (or equivalent)?
The clock starts when a task is moved to a workflow state that is mapped to the "not started" or "in progress" workflow state.
Are weekends included in the cycle time calculations?
Weekends are included in the calculations by default, but you can change that in the chart settings by selecting 'Exclude non-business hours. See How to set weekend days and office hours
What is the difference between these metrics?
Reaction time = time before the work was started
Cycle time = time from start to completion
Lead time = Reaction time + Cycle time
Timing metrics explained: Lead time vs Cycle time
How is the reaction time calculated?
Reaction time starts running when a task is moved into a state that is mapped to the "Not started" in the workflow mapping. The reaction time stops when the task is moved out from that state. If the task is never placed into a state that is mapped to the “Not started” workflow state, then the reaction time is zero.
What if tasks skip lists/columns, or there is no sequential workflow?
The timing information is based on how long items stay in the workflow states that are mapped to "In progress" in the workflow mapping. There is no need for sequential progress, and it is totally fine if tasks skip some of the workflow steps.
What if a task is moved from the “not started” state directly to “done” without going through any of the “in progress” states?
In that case, the cycle time will be zero.
How does the cycle time work if a task is moved into "in progress" and then back to "not started yet"? Similarly, what happens if a card is archived while it's in progress?
Cycle time is calculated only for completed tasks, so in both of those cases, cycle time would be undefined.
If a task is moved from "in progress" to "done", but then back to "in progress" again for additional work would this time be added to the cycle time?
Cycle time is counted only when the task is in progress, so the time spent in the "done" state is not included in the calculation.
When is a task created? Does the clock start when a task is created or when it is put in the "next" state (or equivalent)?
The clock starts when a task is moved to a workflow state that is mapped to the "not started" or "in progress" workflow state.
Are weekends included in the cycle time calculations?
Weekends are included in the calculations by default, but you can change that in the chart settings by selecting 'Exclude non-business hours. See How to set weekend days and office hours
By default yes, but you can specify your working hours and days in the Account Settings.
By default yes, but you can specify your working hours and days in the Account Settings.
Yes, there are a few different ways you can filter out outliers from the charts, including
Filtering by item name
Filtering by how long an item has been in progress
Setting a label and filtering out based on that label
You can learn more from this guide: How to remove outliers from data?
Yes, there are a few different ways you can filter out outliers from the charts, including
Filtering by item name
Filtering by how long an item has been in progress
Setting a label and filtering out based on that label
You can learn more from this guide: How to remove outliers from data?
Does this support my specific workflow or do I have to use some specific states like "open", "in progress" and "done"?
You are not limited to any specific set of states or a workflow. You can configure your own workflow, if such exists, and you can use that in your reporting. It's also ok if you don't have any workflow in your boards, as can create reports based on any other criteria by setting a filter.
You are not limited to any specific set of states or a workflow. You can configure your own workflow, if such exists, and you can use that in your reporting. It's also ok if you don't have any workflow in your boards, as can create reports based on any other criteria by setting a filter.
You can embed any custom chart or report to any web page using the embed code. Learn more about the sharing feature from the online guide.
You can embed any custom chart or report to any web page using the embed code. Learn more about the sharing feature from the online guide.
The Getting Started Guide contains Instructions for setting up Screenful.
See also our Accounts & Pricing FAQ.
Check out our knowledge base and video tutorials, or get in touch by emailing support@screenful.com
The Getting Started Guide contains Instructions for setting up Screenful.
See also our Accounts & Pricing FAQ.
Check out our knowledge base and video tutorials, or get in touch by emailing support@screenful.com
Troubleshooting
While both the public and private channels are shown in the menu, you won’t receive the report to a private channel without explicitly adding the Screenful app to that channel. Learn how to enable sending to a private Slack channel.
There can also be restrictions on who can install apps to your Slack. Learn how to manage app approval in your Slack workspace.
Some browser plugins may interfere with the authorization process. If you see an empty page during the authorization or the list of channels is empty, you should try with another browser (or ask your colleague to do the Slack authorization).
While both the public and private channels are shown in the menu, you won’t receive the report to a private channel without explicitly adding the Screenful app to that channel. Learn how to enable sending to a private Slack channel.
There can also be restrictions on who can install apps to your Slack. Learn how to manage app approval in your Slack workspace.
Some browser plugins may interfere with the authorization process. If you see an empty page during the authorization or the list of channels is empty, you should try with another browser (or ask your colleague to do the Slack authorization).
Filter options are derived from task data, which means that if you recently added some properties, such as labels, but haven't yet assigned them to any tasks, they won't show up in the filter options. As soon as you assign them to tasks, they will show up in the filter options from then on.
Filter options are derived from task data, which means that if you recently added some properties, such as labels, but haven't yet assigned them to any tasks, they won't show up in the filter options. As soon as you assign them to tasks, they will show up in the filter options from then on.
If you or your colleague didn't receive the user invitation email, you can go to the user settings and click the Copy invitation link button to copy the link to the clipboard. After that, you can share the link via any channel (email, Slack, Teams, etc). You can learn more from the user invitation guide.
If you or your colleague didn't receive the user invitation email, you can go to the user settings and click the Copy invitation link button to copy the link to the clipboard. After that, you can share the link via any channel (email, Slack, Teams, etc). You can learn more from the user invitation guide.