NEW - Deploys per days

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

WITH issues_info AS (
	SELECT
		version_id,
		MIN(status_category_change_date) + interval '3 hour' AS deploy_date
	FROM 
		jira.jira_issues_summary
	WHERE
		status_name = 'DONE' AND
		team_key IN ($teams) AND
		version_id IS NOT NULL
	GROUP BY version_id
	HAVING MIN(status_category_change_date) BETWEEN $__timeFrom() AND $__timeTo()
	ORDER BY deploy_date
)
SELECT 
 deploy_date AS time,
 COUNT(version_id) AS deploys
FROM issues_info
GROUP BY time