Asana: Team

Description

• Enriched team table consisting of basic team info + task/completion metrics (note that teams can only act on tasks in projects)

Supported Data Sources

• Asana

Columns

Type	Name	Description
INTEGER	team_id	System generate unique ID for the team
STRING	team_name	UI-facing name of the team.
INTEGER	number_of_open_tasks	Count of the currently open tasks for this team.
INTEGER	number_of_assigned_open_tasks	Count of the open and assigned tasks for the team.
INTEGER	number_of_tasks_completed	Count of tasks that this team has completed.
INTEGER	avg_close_time_days	The avg number of days it has taken projects of this team to close tasks.
INTEGER	avg_close_time_assigned_days	The avg number of days it has taken projects of this team to close tasks, once assigned
INTEGER	number_of_active_projects	Count of non-archived projects
STRING	active_projects	Aggregated list of non archived projects associated with the team
INTEGER	number_of_archived_projects	Count of archived projects