Create charts based on time tracking data

Create charts based on time tracking data

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.

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.

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.

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:

Add new chart in charts, select actual time

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:

Metric with total sum of actual time

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

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

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:

Add new chart in charts, select actual time

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:

Metric with total sum of actual time

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

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:

Group by time logged by

And here’s the resulting chart:

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.

Filter by same property

When you select individuals, the chart is filtered accordingly.

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:

Group by time logged by

And here’s the resulting chart:

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.

Filter by same property

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:

Actual time as column

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

Time logged by result

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:

Actual time as column

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

Time logged by result

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:

Select actual time from add new chart

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

Reveaks date range menu in chart

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:

Select actual time from add new chart

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

Reveaks date range menu in chart

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.

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:

Enable 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:

Time logged by in quick filter

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

Select individually from the menu

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:

Enable 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:

Time logged by in quick filter

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

Select individually from the menu

Create a time-tracking report from template

You can create a time-tracking report by using a report template. Go to the Reports tab and click Add new report:

Add new report

A modal opens, showing the available templates. Select Time tracking for Asana:

Select time tracking for asana

A report is created containing time tracking data from the selected Asana projects.

Report created

Create a time-tracking report from template

You can create a time-tracking report by using a report template. Go to the Reports tab and click Add new report:

Add new report

A modal opens, showing the available templates. Select Time tracking for Asana:

Select time tracking for asana

A report is created containing time tracking data from the selected Asana projects.

Report created