Jira: User Enhanced

Description

• Table of users enriched with their projects, and the volume and velocity of their issues.

Supported Data Sources

• Jira

Columns

Type	Name	Description
INTEGER	email	Email associated with the user acccount.
STRING	user_id	Unique ID of the user.
STRING	locale	The Java locale of the user.
STRING	user_display_name	Name of the user as it appears in the UI.
STRING	time_zone	The user's timezone, as defined in their settings.
INTEGER	username	Account username.
DATETIME	_fivetran_synced
STRING	projects	Comma-separated list of projects on which the user has been assigned to.
INTEGER	count_closed_issues	The number of issues that the user has closed (while being assigned to).
INTEGER	count_open_issues	The number of currently open issues that the user is assigned to.
DECIMAL	avg_close_time_days	The average time taken to close issues since assignment, in days.
DECIMAL	avg_age_currently_open_days	The average age of a user's currently open issues.
DECIMAL	median_close_time_days	The median time taken to close issues since assignment, in days.
DECIMAL	median_age_currently_open_days	The median age of a user's currently open issues.
DECIMAL	avg_close_time_seconds	The average time taken to close issues since assignment, in seconds.
DECIMAL	avg_age_currently_open_seconds	Tjhe average age of a user's currently open issues.
DECIMAL	median_close_time_seconds	The median time taken to close issues since assignment, in seconds.
DECIMAL	median_age_currently_open_seconds	The median age of a user's currently open issues.