Create charts based on time tracking data

If you have enabled time tracking on any of your Asana projects, the Estimated time and Actual time will be automatically imported and made available for charts. You can create charts based on time tracking data in the same way you create charts based on task data. You have all the same grouping and filtering options available.

Guide contents:

Creating a chart using Asana time tracking data

Grouping and filtering by time logged by

Time logged by individual by task

Time logged by individual by task within a date range

Setting a quick filter for selecting an individual

Create a time-tracking report from template

Guide contents:

Creating a chart using Asana time tracking data

Grouping and filtering by time logged by

Time logged by individual by task

Time logged by individual by task within a date range

Setting a quick filter for selecting an individual

Create a time-tracking report from template

Creating a chart using Asana time tracking data

To create a chart using time tracking data, start by clicking Add new chart in the Charts tab. Select the data sources for the chart. If any of those data sources contain the Actual time field, it can be selected in the Unit menu:

When Actual time is selected as the Unit, the Metric menu contains only one option: Total (sum of Actual time). Here’s an example configuration of a line chart that shows the total amount of hours logged over time:

The Date range refers to when the hours were logged. Here’s the resulting chart:

You can create charts from your top-level tasks, subtasks, or both. You can choose between these options by setting a filter (use the filter Item type).

Creating a chart using Asana time tracking data

The Date range refers to when the hours were logged. Here’s the resulting chart:

You can create charts from your top-level tasks, subtasks, or both. You can choose between these options by setting a filter (use the filter Item type).

Grouping and filtering by time logged by

When Actual time is selected as a unit, a special metric called Time logged by allows grouping and filtering based on who logged the hours. Here’s an example chart configuration showing the total amount of hours logged per individual:

And here’s the resulting chart:

You can also filter the chart based on this property. In the filter window, you can find the Time logged by (Actual time) option.

When you select individuals, the chart is filtered accordingly.

Grouping and filtering by time logged by

And here’s the resulting chart:

You can also filter the chart based on this property. In the filter window, you can find the Time logged by (Actual time) option.

When you select individuals, the chart is filtered accordingly.

Time logged by individual by task

You can track time logged by an individual in a Task list by adding Actual time (Time logged by) as a column:

That allows you to see how much time each team member logged for each item:

The numbers are summed so that you can see each team member's total time logged so far.

Time logged by individual by task

You can track time logged by an individual in a Task list by adding Actual time (Time logged by) as a column:

That allows you to see how much time each team member logged for each item:

The numbers are summed so that you can see each team member's total time logged so far.

Time logged by individual by task within a date range

To see how many hours have been logged by team member by task within a time period, select Actual time (within date range) from the menu:

Selecting it reveals a date range menu that allows you to narrow the results to tasks with time logged within the selected period.

Now the Actual time and Actual time (Time logged by) show the total time logged to tasks within the specified date range. You can use the filter feature to narrow the list to any subset of tasks.

Time logged by individual by task within a date range

To see how many hours have been logged by team member by task within a time period, select Actual time (within date range) from the menu:

Selecting it reveals a date range menu that allows you to narrow the results to tasks with time logged within the selected period.

Setting a quick filter for selecting an individual

In the chart settings, you can configure a quick filter that will be shown at the top of the chart. If you set a quick filter for Time logged by (Actual time), you can easily filter the report to see each individual's timesheet.

In the chart settings, use the toggle to enable the quick filter:

Clicking the toggle reveals the filter options. These are the same options as when setting a filter in the chart editor. Select Time logged by (Actual time) from the list:

Once a quick filter is enabled, you can filter the list by any individual by picking a name from the menu:

Setting a quick filter for selecting an individual

In the chart settings, use the toggle to enable the quick filter:

Clicking the toggle reveals the filter options. These are the same options as when setting a filter in the chart editor. Select Time logged by (Actual time) from the list: