NEW - Lead Time

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

WITH lead_time_info AS (
	SELECT
 		PR.title,
		EXTRACT(EPOCH FROM JI.status_category_change_date_time - PR.created_date_time) AS lead_time_created,
		EXTRACT(EPOCH FROM JI.status_category_change_date_time - PR.merged_date_time) AS lead_time_merged
 	FROM jira.jira_issues_summary JI
	INNER JOIN github.git_pull_requests_summary PR ON JI.key = PR.key
 	WHERE
 		JI.status_name = 'DONE' AND
	 JI.team_key IN ($teams) AND
		PR.state = 'closed' AND
		$__timeFilter(JI.status_category_change_date_time)
	ORDER BY lead_time_created DESC
)
SELECT
	PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY lead_time_created) AS median_lead_time_created,
	PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY lead_time_merged) AS median_lead_time_merged,
	PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY lead_time_merged) AS seventyfive_lead_time_merged,
	AVG(lead_time_merged) AS avg_lead_time_merged,
	count(title) as Throughput
FROM lead_time_info;