Jira: Project Enhanced

Description

• Table of projects enriched with data about its lead, epics, components, and volume and velocity of worktime.

Supported Data Sources

• Jira

Columns

Type	Name	Description
INTEGER	project_description	Description of the project, if given.
INTEGER	project_id	Unique ID of the project.
STRING	project_key	UI-facing ID of the project. This becomes the default prefix for tasks created within this project.
STRING	project_lead_user_id	Foreign key referencing the ID of the user who leads this project.
STRING	project_name	Title of the project.
INTEGER	project_category_id	Foreign key referencing the ID of the project_category that the project is associated with, if any.
INTEGER	permission_scheme_id	Foreign key referencing the ID of the permission_scheme that the project ascribes to.
DATETIME	_fivetran_synced
STRING	project_lead_user_name	User display name of the person leading this project.
INTEGER	project_lead_email	Email associated with the project lead.
STRING	epics	Comma-separated list of epics worked on in this project.
STRING	components	Comma-separated list of components of this project.
INTEGER	count_closed_issues	The number of issues closed in this project.
INTEGER	count_open_issues	The number of currently un-resolved issues in the project.
INTEGER	count_open_assigned_issues	The number of currently open and currently assigned issues in the project.
DECIMAL	avg_close_time_days	The average time taken to close issues, in days.
DECIMAL	avg_assigned_close_time_days	The average time taken to close issues from their first assignment, in days.
DECIMAL	avg_age_currently_open_days	The average age of any currently-open issues.
DECIMAL	avg_age_currently_open_assigned_days	The average age of any currently-open issues, from their first assignment.
DECIMAL	median_close_time_days	The median time taken to close issues, in days.
DECIMAL	median_age_currently_open_days	The median age of any currently-open issues.
DECIMAL	median_assigned_close_time_days	The median time taken to close issues from their first assignment, in days.
DECIMAL	median_age_currently_open_assigned_days	The median age of any currently-open issues, from their first assignment.
DECIMAL	avg_close_time_seconds	The average time taken to close issues, in seconds.
DECIMAL	avg_assigned_close_time_seconds	The average time taken to close issues from their first assignment, in seconds.
DECIMAL	avg_age_currently_open_seconds	The average age of any currently-open issues.
DECIMAL	avg_age_currently_open_assigned_seconds	The average age of any currently-open issues, from their first assignment.
DECIMAL	median_close_time_seconds	The median time taken to close issues, in seconds.
DECIMAL	median_age_currently_open_seconds	The median age of any currently-open issues.
DECIMAL	median_assigned_close_time_seconds	The median time taken to close issues from their first assignment, in seconds.
DECIMAL	median_age_currently_open_assigned_seconds	The median age of any currently-open issues, from their first assignment.