This is an automated email from the ASF dual-hosted git repository. abeizn pushed a commit to branch release-v0.16 in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
commit 9af4124af906f0ec0973524c70fd1b179a477357 Author: abeizn <[email protected]> AuthorDate: Fri Apr 21 17:31:40 2023 +0800 fix: case inconsistency in sql (#4997) * fix: case inconsistency in sql * fix: weekly bug retro select repo --- grafana/dashboards/BitBucket.json | 6 +++--- grafana/dashboards/ComponentAndFileLevelMetrics.json | 8 ++++---- grafana/dashboards/ContributorExperience.json | 12 ++++++------ grafana/dashboards/DORA.json | 12 ++++++------ .../DemoAverageRequirementLeadTimeByAssignee.json | 8 ++++---- grafana/dashboards/DemoCommitCountByAuthor.json | 4 ++-- grafana/dashboards/DemoDetailedBugInfo.json | 8 ++++---- ...DemoHowFastDoWeRespondToCustomerRequirements.json | 4 ++-- .../DemoIsThisMonthMoreProductiveThanLast.json | 4 ++-- .../dashboards/DemoWasOurQualityImprovedOrNot.json | 4 ++-- grafana/dashboards/EngineeringOverview.json | 6 +++--- .../EngineeringThroughputAndCycleTime.json | 6 +++--- .../EngineeringThroughputAndCycleTimeTeamView.json | 6 +++--- grafana/dashboards/GitHub.json | 20 ++++++++++---------- .../GithubReleaseQualityAndContributionAnalysis.json | 6 +++--- grafana/dashboards/Gitlab.json | 18 +++++++++--------- grafana/dashboards/Jenkins.json | 6 +++--- grafana/dashboards/Jira.json | 6 +++--- grafana/dashboards/Sonarqube.json | 12 ++++++------ grafana/dashboards/TAPD.json | 4 ++-- grafana/dashboards/WeeklyCommunityRetro.json | 6 +++--- 21 files changed, 83 insertions(+), 83 deletions(-) diff --git a/grafana/dashboards/BitBucket.json b/grafana/dashboards/BitBucket.json index 45ccaf825..0d2060d66 100644 --- a/grafana/dashboards/BitBucket.json +++ b/grafana/dashboards/BitBucket.json @@ -15,8 +15,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 12, - "iteration": 1679476420040, + "id": 28, + "iteration": 1682062771301, "links": [], "panels": [ { @@ -966,5 +966,5 @@ "timezone": "", "title": "BitBucket", "uid": "4LzQHZa4k", - "version": 16 + "version": 1 } \ No newline at end of file diff --git a/grafana/dashboards/ComponentAndFileLevelMetrics.json b/grafana/dashboards/ComponentAndFileLevelMetrics.json index ab49cce0e..d8f08e498 100644 --- a/grafana/dashboards/ComponentAndFileLevelMetrics.json +++ b/grafana/dashboards/ComponentAndFileLevelMetrics.json @@ -16,8 +16,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 17, - "iteration": 1677030964408, + "id": 20, + "iteration": 1682062815355, "links": [], "panels": [ { @@ -991,7 +991,7 @@ { "allValue": null, "current": { - "selected": false, + "selected": true, "text": [ "All" ], @@ -1061,5 +1061,5 @@ "timezone": "", "title": "Component and File-level Metrics", "uid": "KxUh7IG4z", - "version": 4 + "version": 3 } \ No newline at end of file diff --git a/grafana/dashboards/ContributorExperience.json b/grafana/dashboards/ContributorExperience.json index 678b3c4ab..9a77d2294 100644 --- a/grafana/dashboards/ContributorExperience.json +++ b/grafana/dashboards/ContributorExperience.json @@ -15,8 +15,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 21, - "iteration": 1677590412757, + "id": 24, + "iteration": 1682062826895, "links": [], "panels": [ { @@ -508,7 +508,7 @@ "metricColumn": "none", "queryType": "randomWalk", "rawQuery": true, - "rawSql": "select\n\tavg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\nfrom \n\tpull_requests pr\nwhere \n date(created_date) BETWEEN\n curdate() - INTERVAL DAYOFMONTH(curdate())-1 DAY - INTERVAL 1 month and\n curdate() - INTERVAL DAYOFMONTH(curdate()) DAY\n\tand status in ('closed', 'merged', 'declined')\n\tand pr.base_repo_id in ($repo_id)\n\n\n", + "rawSql": "select\n\tavg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\nfrom \n\tpull_requests pr\nwhere \n date(created_date) BETWEEN\n curdate() - INTERVAL DAYOFMONTH(curdate())-1 DAY - INTERVAL 1 month and\n curdate() - INTERVAL DAYOFMONTH(curdate()) DAY\n\tand status in ('CLOSED', 'MERGED', 'DECLINED')\n\tand pr.base_repo_id in ($repo_id)\n\n\n", "refId": "A", "select": [ [ @@ -590,7 +590,7 @@ "metricColumn": "none", "queryType": "randomWalk", "rawQuery": true, - "rawSql": "select\n 100 * sum(case when TIMESTAMPDIFF(Minute, created_date, closed_date) / 1440 < $prrt_sla then 1 else null end) / count(*)\nfrom \n\tpull_requests pr\nwhere \n date(created_date) BETWEEN\n curdate() - INTERVAL DAYOFMONTH(curdate())-1 DAY - INTERVAL 1 month and\n curdate() - INTERVAL DAYOFMONTH(curdate()) DAY\n\tand status in ('closed', 'merged', 'declined')\n\tand pr.base_repo_id in ($repo_id)\n\n\n", + "rawSql": "select\n 100 * sum(case when TIMESTAMPDIFF(Minute, created_date, closed_date) / 1440 < $prrt_sla then 1 else null end) / count(*)\nfrom \n\tpull_requests pr\nwhere \n date(created_date) BETWEEN\n curdate() - INTERVAL DAYOFMONTH(curdate())-1 DAY - INTERVAL 1 month and\n curdate() - INTERVAL DAYOFMONTH(curdate()) DAY\n\tand status in ('CLOSED', 'MERGED', 'DECLINED')\n\tand pr.base_repo_id in ($repo_id)\n\n\n", "refId": "A", "select": [ [ @@ -672,7 +672,7 @@ "metricColumn": "none", "queryType": "randomWalk", "rawQuery": true, - "rawSql": "select\n 100 * count(distinct case when status in ('closed', 'merged', 'declined') and merged_date is null then id else null end)/count(distinct case when status in ('closed', 'merged', 'declined') then id else null end) as ratio\nfrom \n\tpull_requests pr\nwhere\n date(created_date) BETWEEN\n curdate() - INTERVAL DAYOFMONTH(curdate())-1 DAY - INTERVAL 1 month and\n curdate() - INTERVAL DAYOFMONTH(curdate()) DAY\n and pr.base_repo_id in ($repo_id)", + "rawSql": "select\n 100 * count(distinct case when status in ('CLOSED', 'MERGED', 'DECLINED') and merged_date is null then id else null end)/count(distinct case when status in ('CLOSED', 'MERGED', 'DECLINED') then id else null end) as ratio\nfrom \n\tpull_requests pr\nwhere\n date(created_date) BETWEEN\n curdate() - INTERVAL DAYOFMONTH(curdate())-1 DAY - INTERVAL 1 month and\n curdate() - INTERVAL DAYOFMONTH(curdate()) DAY\n and pr.base_repo_id in ($repo_id)", "refId": "A", "select": [ [ @@ -828,5 +828,5 @@ "timezone": "", "title": "Contributor Experience", "uid": "bwsP5Nz4z", - "version": 6 + "version": 9 } \ No newline at end of file diff --git a/grafana/dashboards/DORA.json b/grafana/dashboards/DORA.json index ab0cf6730..a6a5babf5 100644 --- a/grafana/dashboards/DORA.json +++ b/grafana/dashboards/DORA.json @@ -15,8 +15,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 12, - "iteration": 1681911584843, + "id": 9, + "iteration": 1682062927185, "links": [], "panels": [ { @@ -143,7 +143,7 @@ "metricColumn": "none", "queryType": "randomWalk", "rawQuery": true, - "rawSql": "-- Metric 1: Deployment Frequency\nwith last_few_calendar_months as(\n-- get the last few months within the selected time period in the top-right corner\n\tSELECT CAST((SYSDATE()-INTERVAL (H+T+U) DAY) AS date) day\n\tFROM ( SELECT 0 H\n\t\t\tUNION ALL SELECT 100 UNION ALL SELECT 200 UNION ALL SELECT 300\n\t\t) H CROSS JOIN ( SELECT 0 T\n\t\t\tUNION ALL SELECT 10 UNION ALL SELECT 20 UNION ALL SELECT 30\n\t\t\tUNION ALL SELECT 40 UNION ALL SELECT 50 UNION ALL SELE [...] + "rawSql": "-- Metric 1: Deployment Frequency\nwith last_few_calendar_months as(\n-- get the last few months within the selected time period in the top-right corner\n\tSELECT CAST((SYSDATE()-INTERVAL (H+T+U) DAY) AS date) day\n\tFROM ( SELECT 0 H\n\t\t\tUNION ALL SELECT 100 UNION ALL SELECT 200 UNION ALL SELECT 300\n\t\t) H CROSS JOIN ( SELECT 0 T\n\t\t\tUNION ALL SELECT 10 UNION ALL SELECT 20 UNION ALL SELECT 30\n\t\t\tUNION ALL SELECT 40 UNION ALL SELECT 50 UNION ALL SELE [...] "refId": "A", "select": [ [ @@ -543,7 +543,7 @@ "metricColumn": "none", "queryType": "randomWalk", "rawQuery": true, - "rawSql": "-- Metric 4: change failure rate\nwith _deployments as (\n-- get the deployment deployed within the selected time period in the top-right corner\n\tSELECT\n\t\tct.id AS deployment_id,\n\t\tct.finished_date as deployment_finished_date\n\tFROM\n\t\tcicd_tasks ct\n\t\tjoin project_mapping pm on ct.cicd_scope_id = pm.row_id\n\tWHERE\n\t pm.project_name in ($project)\n\t\tand type = 'DEPLOYMENT'\n\t\tand result = 'SUCCESS'\n\t\tand environment = 'PRODUCTION'\n and $__ [...] + "rawSql": "-- Metric 4: change failure rate\nwith _deployments as (\n-- get the deployment deployed within the selected time period in the top-right corner\n\tSELECT\n\t\tct.id AS deployment_id,\n\t\tct.finished_date as deployment_finished_date\n\tFROM\n\t\tcicd_tasks ct\n\t\tjoin project_mapping pm on ct.cicd_scope_id = pm.row_id\n\tWHERE\n\t pm.project_name in ($project)\n\t\tand type = 'DEPLOYMENT'\n\t\tand result = 'SUCCESS'\n\t\tand environment = 'PRODUCTION'\n and $__ [...] "refId": "A", "select": [ [ @@ -953,7 +953,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "-- Metric 4: change failure rate\nwith _deployments as (\n-- get the deployment deployed within the selected time period in the top-right corner\n\tSELECT\n\t\tct.id AS deployment_id,\n\t\tct.finished_date as deployment_finished_date\n\tFROM\n\t\tcicd_tasks ct\n\t\tjoin project_mapping pm on ct.cicd_scope_id = pm.row_id\n\tWHERE\n\t pm.project_name in ($project)\n\t\tand type = 'DEPLOYMENT'\n\t\tand result = 'SUCCESS'\n\t\tand environment = 'PRODUCTION'\n and $__ [...] + "rawSql": "-- Metric 4: change failure rate\nwith _deployments as (\n-- get the deployment deployed within the selected time period in the top-right corner\n\tSELECT\n\t\tct.id AS deployment_id,\n\t\tct.finished_date as deployment_finished_date\n\tFROM\n\t\tcicd_tasks ct\n\t\tjoin project_mapping pm on ct.cicd_scope_id = pm.row_id\n\tWHERE\n\t pm.project_name in ($project)\n\t\tand type = 'DEPLOYMENT'\n\t\tand result = 'SUCCESS'\n\t\tand environment = 'PRODUCTION'\n and $__ [...] "refId": "A", "select": [ [ @@ -1027,5 +1027,5 @@ "timezone": "", "title": "DORA", "uid": "qNo8_0M4z", - "version": 2 + "version": 13 } \ No newline at end of file diff --git a/grafana/dashboards/DemoAverageRequirementLeadTimeByAssignee.json b/grafana/dashboards/DemoAverageRequirementLeadTimeByAssignee.json index 38297e291..3f17d0143 100644 --- a/grafana/dashboards/DemoAverageRequirementLeadTimeByAssignee.json +++ b/grafana/dashboards/DemoAverageRequirementLeadTimeByAssignee.json @@ -15,7 +15,7 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 3, + "id": 1, "links": [ { "asDropdown": false, @@ -111,7 +111,7 @@ "metricColumn": "none", "queryType": "randomWalk", "rawQuery": true, - "rawSql": "with _requirements as(\n select \n DATE_ADD(date(resolution_date), INTERVAL -DAY(date(resolution_date))+1 DAY) as time,\n assignee_name as assignee,\n avg(lead_time_minutes)/1440 as lead_time\n from issues i\n where \n type = 'Requirement'\n and assignee_id != ''\n and $__timeFilter(resolution_date)\n group by 1,2\n),\n\n\nthis_month as(\n\tselect \n\t\tDATE_ADD(date(CURDATE()), INTERVAL -DAY(date(CURDATE()))+1 DAY) as this_month\n),\n\nlast_mon [...] + "rawSql": "with _requirements as(\n select \n DATE_ADD(date(resolution_date), INTERVAL -DAY(date(resolution_date))+1 DAY) as time,\n assignee_name as assignee,\n avg(lead_time_minutes)/1440 as lead_time\n from issues i\n where \n type = 'REQUIREMENT'\n and assignee_id != ''\n and $__timeFilter(resolution_date)\n group by 1,2\n),\n\n\nthis_month as(\n\tselect \n\t\tDATE_ADD(date(CURDATE()), INTERVAL -DAY(date(CURDATE()))+1 DAY) as this_month\n),\n\nlast_mon [...] "refId": "A", "select": [ [ @@ -182,7 +182,7 @@ "metricColumn": "none", "queryType": "randomWalk", "rawQuery": true, - "rawSql": "with _requirements as(\n select \n DATE_ADD(date(resolution_date), INTERVAL -DAY(date(resolution_date))+1 DAY) as time,\n assignee_name as assignee,\n avg(lead_time_minutes)/1440 as lead_time\n from issues i\n where \n type = 'Requirement'\n and assignee_id != ''\n and $__timeFilter(resolution_date)\n group by 1,2\n),\n\n\nthis_month as(\n\tselect \n\t\tDATE_ADD(date(CURDATE()), INTERVAL -DAY(date(CURDATE()))+1 DAY) as this_month\n),\n\nlast_mon [...] + "rawSql": "with _requirements as(\n select \n DATE_ADD(date(resolution_date), INTERVAL -DAY(date(resolution_date))+1 DAY) as time,\n assignee_name as assignee,\n avg(lead_time_minutes)/1440 as lead_time\n from issues i\n where \n type = 'REQUIREMENT'\n and assignee_id != ''\n and $__timeFilter(resolution_date)\n group by 1,2\n),\n\n\nthis_month as(\n\tselect \n\t\tDATE_ADD(date(CURDATE()), INTERVAL -DAY(date(CURDATE()))+1 DAY) as this_month\n),\n\nlast_mon [...] "refId": "A", "select": [ [ @@ -246,5 +246,5 @@ "timezone": "", "title": "Demo-Average Requirement Lead Time By Assignee", "uid": "q27fk7cnk", - "version": 2 + "version": 6 } \ No newline at end of file diff --git a/grafana/dashboards/DemoCommitCountByAuthor.json b/grafana/dashboards/DemoCommitCountByAuthor.json index 57a6c8914..e98fcf702 100644 --- a/grafana/dashboards/DemoCommitCountByAuthor.json +++ b/grafana/dashboards/DemoCommitCountByAuthor.json @@ -15,7 +15,7 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 4, + "id": 5, "links": [ { "asDropdown": false, @@ -253,5 +253,5 @@ "timezone": "", "title": "Demo-Commit Count by Author", "uid": "F0iYknc7z", - "version": 2 + "version": 3 } \ No newline at end of file diff --git a/grafana/dashboards/DemoDetailedBugInfo.json b/grafana/dashboards/DemoDetailedBugInfo.json index 602599cab..df10f937d 100644 --- a/grafana/dashboards/DemoDetailedBugInfo.json +++ b/grafana/dashboards/DemoDetailedBugInfo.json @@ -15,7 +15,7 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 10, + "id": 2, "links": [ { "asDropdown": false, @@ -114,7 +114,7 @@ "metricColumn": "none", "queryType": "randomWalk", "rawQuery": true, - "rawSql": "with bugs as(\n select \n DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1 DAY) as time,\n count(*) as bug_count\n from issues i\n where \n type = 'Bug'\n and $__timeFilter(created_date)\n group by 1\n order by 1 desc\n)\n\nselect\n date_format(time,'%M %Y') as month,\n bug_count as 'Bug Count over Month'\nfrom bugs\norder by time asc", + "rawSql": "with bugs as(\n select \n DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1 DAY) as time,\n count(*) as bug_count\n from issues i\n where \n type = 'BUG'\n and $__timeFilter(created_date)\n group by 1\n order by 1 desc\n)\n\nselect\n date_format(time,'%M %Y') as month,\n bug_count as 'Bug Count over Month'\nfrom bugs\norder by time asc", "refId": "A", "select": [ [ @@ -249,7 +249,7 @@ "metricColumn": "none", "queryType": "randomWalk", "rawQuery": true, - "rawSql": "select \n title,\n description,\n case when assignee_id = '' then '-' else assignee_name end as assignee,\n status,\n created_date,\n url\n from issues i\n where \n type = 'Bug'\n and $__timeFilter(created_date)\n order by created_date desc", + "rawSql": "select \n title,\n description,\n case when assignee_id = '' then '-' else assignee_name end as assignee,\n status,\n created_date,\n url\n from issues i\n where \n type = 'BUG'\n and $__timeFilter(created_date)\n order by created_date desc", "refId": "A", "select": [ [ @@ -311,5 +311,5 @@ "timezone": "", "title": "Demo-Detailed Bug Info", "uid": "s48Lzn5nz", - "version": 2 + "version": 8 } \ No newline at end of file diff --git a/grafana/dashboards/DemoHowFastDoWeRespondToCustomerRequirements.json b/grafana/dashboards/DemoHowFastDoWeRespondToCustomerRequirements.json index f3824b28b..863541eb4 100644 --- a/grafana/dashboards/DemoHowFastDoWeRespondToCustomerRequirements.json +++ b/grafana/dashboards/DemoHowFastDoWeRespondToCustomerRequirements.json @@ -108,7 +108,7 @@ "group": [], "metricColumn": "none", "rawQuery": true, - "rawSql": "with _requirements as(\n select \n DATE_ADD(date(resolution_date), INTERVAL -DAY(date(resolution_date))+1 DAY) as time,\n avg(lead_time_minutes)/1440 as lead_time_days\n from issues i\n where \n type = 'Requirement'\n and $__timeFilter(resolution_date)\n group by time\n)\n\nselect\n date_format(time,'%M %Y') as month,\n lead_time_days as 'Average Requirement Lead Time (day)'\nfrom _requirements\norder by time asc", + "rawSql": "with _requirements as(\n select \n DATE_ADD(date(resolution_date), INTERVAL -DAY(date(resolution_date))+1 DAY) as time,\n avg(lead_time_minutes)/1440 as lead_time_days\n from issues i\n where \n type = 'REQUIREMENT'\n and $__timeFilter(resolution_date)\n group by time\n)\n\nselect\n date_format(time,'%M %Y') as month,\n lead_time_days as 'Average Requirement Lead Time (day)'\nfrom _requirements\norder by time asc", "refId": "A", "select": [ [ @@ -219,5 +219,5 @@ "timezone": "", "title": "Demo-How fast do we respond to customer requirements?", "uid": "SupYz7c7z", - "version": 2 + "version": 4 } \ No newline at end of file diff --git a/grafana/dashboards/DemoIsThisMonthMoreProductiveThanLast.json b/grafana/dashboards/DemoIsThisMonthMoreProductiveThanLast.json index a3a0def17..520b41f7c 100644 --- a/grafana/dashboards/DemoIsThisMonthMoreProductiveThanLast.json +++ b/grafana/dashboards/DemoIsThisMonthMoreProductiveThanLast.json @@ -15,7 +15,7 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 5, + "id": 12, "links": [ { "asDropdown": false, @@ -249,5 +249,5 @@ "timezone": "", "title": "Demo-Is this month more productive than last?", "uid": "ddREk75nk", - "version": 2 + "version": 3 } \ No newline at end of file diff --git a/grafana/dashboards/DemoWasOurQualityImprovedOrNot.json b/grafana/dashboards/DemoWasOurQualityImprovedOrNot.json index 7d9e2c787..acb70c618 100644 --- a/grafana/dashboards/DemoWasOurQualityImprovedOrNot.json +++ b/grafana/dashboards/DemoWasOurQualityImprovedOrNot.json @@ -109,7 +109,7 @@ "metricColumn": "none", "queryType": "randomWalk", "rawQuery": true, - "rawSql": "with line_of_code as (\n\tselect \n\t DATE_ADD(date(authored_date), INTERVAL -DAY(date(authored_date))+1 DAY) as time,\n\t sum(additions + deletions) as line_count\n\tfrom \n\t commits\n\twhere \n\t message not like 'Merge%'\n\t and $__timeFilter(authored_date)\n\tgroup by 1\n),\n\n\nbug_count as(\n select \n DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1 DAY) as time,\n count(*) as bug_count\n from issues i\n where \n type = 'Bug'\ [...] + "rawSql": "with line_of_code as (\n\tselect \n\t DATE_ADD(date(authored_date), INTERVAL -DAY(date(authored_date))+1 DAY) as time,\n\t sum(additions + deletions) as line_count\n\tfrom \n\t commits\n\twhere \n\t message not like 'Merge%'\n\t and $__timeFilter(authored_date)\n\tgroup by 1\n),\n\n\nbug_count as(\n select \n DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1 DAY) as time,\n count(*) as bug_count\n from issues i\n where \n type = 'BUG'\ [...] "refId": "A", "select": [ [ @@ -216,5 +216,5 @@ "timezone": "", "title": "Demo-Was our quality improved or not?", "uid": "G4DEk75nz", - "version": 2 + "version": 4 } \ No newline at end of file diff --git a/grafana/dashboards/EngineeringOverview.json b/grafana/dashboards/EngineeringOverview.json index 9fd1c7a00..4749fda62 100644 --- a/grafana/dashboards/EngineeringOverview.json +++ b/grafana/dashboards/EngineeringOverview.json @@ -15,8 +15,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 26, - "iteration": 1671764846277, + "id": 25, + "iteration": 1682062941722, "links": [], "panels": [ { @@ -1845,5 +1845,5 @@ "timezone": "", "title": "Engineering Overview", "uid": "ZF6abXX7z", - "version": 5 + "version": 3 } \ No newline at end of file diff --git a/grafana/dashboards/EngineeringThroughputAndCycleTime.json b/grafana/dashboards/EngineeringThroughputAndCycleTime.json index cc3661303..eeeb80ed3 100644 --- a/grafana/dashboards/EngineeringThroughputAndCycleTime.json +++ b/grafana/dashboards/EngineeringThroughputAndCycleTime.json @@ -15,8 +15,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 11, - "iteration": 1673349403459, + "id": 13, + "iteration": 1682062957718, "links": [], "panels": [ { @@ -1645,5 +1645,5 @@ "timezone": "", "title": "Engineering Throughput and Cycle Time", "uid": "Jaaimc67k", - "version": 9 + "version": 3 } \ No newline at end of file diff --git a/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json b/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json index 9b82c7a2a..a0df5d51c 100644 --- a/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json +++ b/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json @@ -15,8 +15,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 12, - "iteration": 1673353935665, + "id": 7, + "iteration": 1682062968493, "links": [], "panels": [ { @@ -2778,5 +2778,5 @@ "timezone": "", "title": "Engineering Throughput and Cycle Time - Team View", "uid": "nJ1ijje7k", - "version": 2 + "version": 6 } \ No newline at end of file diff --git a/grafana/dashboards/GitHub.json b/grafana/dashboards/GitHub.json index 6fe6c5806..30fee78dc 100644 --- a/grafana/dashboards/GitHub.json +++ b/grafana/dashboards/GitHub.json @@ -15,8 +15,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 25, - "iteration": 1677590489731, + "id": 3, + "iteration": 1682062979883, "links": [], "panels": [ { @@ -1164,7 +1164,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "select\n author_name,\n\tcount(*) as merged_pull_request_count\nfrom \n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n and pr.status in ('closed', 'merged', 'declined') and pr.merged_date is not null\ngroup by 1\norder by 2 desc\nlimit 20\n", + "rawSql": "select\n author_name,\n\tcount(*) as merged_pull_request_count\nfrom \n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n and pr.status in ('CLOSED', 'MERGED', 'DECLINED') and pr.merged_date is not null\ngroup by 1\norder by 2 desc\nlimit 20\n", "refId": "A", "select": [ [ @@ -1259,7 +1259,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "select\n count(distinct case when status in ('closed', 'merged') and merged_date is not null then id else null end)/count(distinct case when status in ('closed', 'merged') then id else null end) as ratio\nfrom \n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)", + "rawSql": "select\n count(distinct case when status in ('CLOSED', 'MERGED') and merged_date is not null then id else null end)/count(distinct case when status in ('CLOSED', 'MERGED') then id else null end) as ratio\nfrom \n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)", "refId": "A", "select": [ [ @@ -1362,7 +1362,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL -DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when status != 'closed' then id else null end) as \"PR: Open\",\n count(distinct case when status in ('closed', 'merged') and merged_date is null then id else null end) as \"PR: Closed without merging\",\n count(distinct case when status in ('closed', 'merged') then id else null end) as \"PR: Closed and merged\"\nFROM pull_requests\nWHERE\n $__ti [...] + "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL -DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when status != 'CLOSED' then id else null end) as \"PR: Open\",\n count(distinct case when status in ('CLOSED', 'MERGED') and merged_date is null then id else null end) as \"PR: Closed without merging\",\n count(distinct case when status in ('CLOSED', 'MERGED') then id else null end) as \"PR: Closed and merged\"\nFROM pull_requests\nWHERE\n $__ti [...] "refId": "A", "select": [ [ @@ -1444,7 +1444,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "select\n\tcount(*) as merged_pull_request_count\nfrom \n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand pr.status in ('closed', 'merged') and pr.merged_date is null", + "rawSql": "select\n\tcount(*) as merged_pull_request_count\nfrom \n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand pr.status in ('CLOSED', 'MERGED') and pr.merged_date is null", "refId": "A", "select": [ [ @@ -1549,7 +1549,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL -DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when status in ('closed', 'merged') and merged_date is null then id else null end)/count(distinct case when status in ('closed', 'merged') then id else null end) as ratio\nFROM pull_requests\nWHERE\n $__timeFilter(created_date)\n and base_repo_id in ($repo_id)\ngroup by 1\n", + "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL -DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when status in ('CLOSED', 'MERGED') and merged_date is null then id else null end)/count(distinct case when status in ('CLOSED', 'MERGED') then id else null end) as ratio\nFROM pull_requests\nWHERE\n $__timeFilter(created_date)\n and base_repo_id in ($repo_id)\ngroup by 1\n", "refId": "A", "select": [ [ @@ -1808,7 +1808,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "select\n\tavg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\nfrom \n\tpull_requests\nwhere \n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand status in ('closed', 'merged')\n\n\n", + "rawSql": "select\n\tavg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\nfrom \n\tpull_requests\nwhere \n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand status in ('CLOSED', 'MERGED')\n\n\n", "refId": "A", "select": [ [ @@ -1905,7 +1905,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "with _prs as(\n SELECT\n DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1 DAY) as time,\n avg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\n FROM pull_requests\n WHERE\n $__timeFilter(created_date)\n and created_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH)\n and base_repo_id in ($repo_id)\n and status in ('closed', 'merged')\n group by 1\n)\n\nSELECT \n [...] + "rawSql": "with _prs as(\n SELECT\n DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1 DAY) as time,\n avg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\n FROM pull_requests\n WHERE\n $__timeFilter(created_date)\n and created_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH)\n and base_repo_id in ($repo_id)\n and status in ('CLOSED', 'MERGED')\n group by 1\n)\n\nSELECT \n [...] "refId": "A", "select": [ [ @@ -1999,5 +1999,5 @@ "timezone": "", "title": "GitHub", "uid": "KXWvOFQnz", - "version": 10 + "version": 13 } \ No newline at end of file diff --git a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json index 1642e5370..aa8b9bcc7 100644 --- a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json +++ b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json @@ -15,8 +15,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 7, - "iteration": 1668494309227, + "id": 22, + "iteration": 1682062991983, "links": [], "panels": [ { @@ -2646,5 +2646,5 @@ "timezone": "", "title": "GitHub_Release_Quality_and_Contribution_Analysis", "uid": "2xuOaQUnk4", - "version": 21 + "version": 3 } \ No newline at end of file diff --git a/grafana/dashboards/Gitlab.json b/grafana/dashboards/Gitlab.json index b0f084126..fc6162128 100644 --- a/grafana/dashboards/Gitlab.json +++ b/grafana/dashboards/Gitlab.json @@ -16,7 +16,7 @@ "gnetId": null, "graphTooltip": 0, "id": 26, - "iteration": 1677590524546, + "iteration": 1682063010710, "links": [], "panels": [ { @@ -306,7 +306,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "select\n author_name,\n\tcount(*) as merged_pull_request_count\nfrom \n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand pr.status in ('closed', 'merged') and pr.merged_date is not null\ngroup by 1\norder by 2 desc\nlimit 20\n", + "rawSql": "select\n author_name,\n\tcount(*) as merged_pull_request_count\nfrom \n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand pr.status in ('CLOSED', 'MERGED') and pr.merged_date is not null\ngroup by 1\norder by 2 desc\nlimit 20\n", "refId": "A", "select": [ [ @@ -401,7 +401,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "select\n count(distinct case when status in ('closed', 'merged') and merged_date is null then id else null end)/count(distinct case when status in ('closed', 'merged') then id else null end) as ratio\nfrom \n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)", + "rawSql": "select\n count(distinct case when status in ('CLOSED', 'MERGED') and merged_date is null then id else null end)/count(distinct case when status in ('CLOSED', 'MERGED') then id else null end) as ratio\nfrom \n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)", "refId": "A", "select": [ [ @@ -504,7 +504,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL -DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when status not in ('closed','merged') then id else null end) as \"PR: Open\",\n count(distinct case when status in ('closed', 'merged') and merged_date is null then id else null end) as \"PR: Closed without merging\",\n count(distinct case when status in ('closed', 'merged') and merged_date is not null then id else null end) as \"PR: Merged\"\nFRO [...] + "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL -DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when status not in ('CLOSED', 'MERGED') then id else null end) as \"PR: Open\",\n count(distinct case when status in ('CLOSED', 'MERGED') and merged_date is null then id else null end) as \"PR: Closed without merging\",\n count(distinct case when status in ('CLOSED', 'MERGED') and merged_date is not null then id else null end) as \"PR: Merged\"\nFR [...] "refId": "A", "select": [ [ @@ -586,7 +586,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "select\n\tcount(*) as merged_pull_request_count\nfrom \n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand pr.status in ('closed', 'merged') and pr.merged_date is null", + "rawSql": "select\n\tcount(*) as merged_pull_request_count\nfrom \n\tpull_requests pr\nwhere\n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand pr.status in ('CLOSED', 'MERGED') and pr.merged_date is null", "refId": "A", "select": [ [ @@ -693,7 +693,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL -DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when status in ('closed', 'merged') and merged_date is null then id else null end)/count(distinct case when status in ('closed', 'merged') and merged_date is not null then id else null end) as ratio\nFROM pull_requests\nWHERE\n $__timeFilter(created_date)\n and base_repo_id in ($repo_id)\ngroup by 1\n", + "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL -DAYOFMONTH(date(created_date))+1 DAY) as time,\n count(distinct case when status in ('CLOSED', 'MERGED') and merged_date is null then id else null end)/count(distinct case when status in ('CLOSED', 'MERGED') and merged_date is not null then id else null end) as ratio\nFROM pull_requests\nWHERE\n $__timeFilter(created_date)\n and base_repo_id in ($repo_id)\ngroup by 1\n", "refId": "A", "select": [ [ @@ -952,7 +952,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "select\n\tavg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\nfrom \n\tpull_requests\nwhere \n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand status in ('closed', 'merged')\n\n\n", + "rawSql": "select\n\tavg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\nfrom \n\tpull_requests\nwhere \n $__timeFilter(created_date)\n\tand base_repo_id in ($repo_id)\n\tand status in ('CLOSED', 'MERGED')\n\n\n", "refId": "A", "select": [ [ @@ -1049,7 +1049,7 @@ "hide": false, "metricColumn": "none", "rawQuery": true, - "rawSql": "with _prs as(\n SELECT\n DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1 DAY) as time,\n avg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\n FROM pull_requests\n WHERE\n $__timeFilter(created_date)\n and base_repo_id in ($repo_id)\n and status in ('closed', 'merged')\n and created_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH)\n group by 1\n)\n\nSELECT \n [...] + "rawSql": "with _prs as(\n SELECT\n DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1 DAY) as time,\n avg(TIMESTAMPDIFF(Minute,created_date,closed_date)/1440) as time_to_close\n FROM pull_requests\n WHERE\n $__timeFilter(created_date)\n and base_repo_id in ($repo_id)\n and status in ('CLOSED', 'MERGED')\n and created_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH)\n group by 1\n)\n\nSELECT \n [...] "refId": "A", "select": [ [ @@ -1143,5 +1143,5 @@ "timezone": "", "title": "GitLab", "uid": "msSjEq97z", - "version": 10 + "version": 11 } \ No newline at end of file diff --git a/grafana/dashboards/Jenkins.json b/grafana/dashboards/Jenkins.json index ac153ee4f..fc72fe2c3 100644 --- a/grafana/dashboards/Jenkins.json +++ b/grafana/dashboards/Jenkins.json @@ -15,8 +15,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 33, - "iteration": 1678171137345, + "id": 4, + "iteration": 1682063024677, "links": [], "panels": [ { @@ -971,5 +971,5 @@ "timezone": "", "title": "Jenkins", "uid": "W8AiDFQnk", - "version": 10 + "version": 3 } \ No newline at end of file diff --git a/grafana/dashboards/Jira.json b/grafana/dashboards/Jira.json index 3b703ce8c..ed53692a9 100644 --- a/grafana/dashboards/Jira.json +++ b/grafana/dashboards/Jira.json @@ -15,8 +15,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 20, - "iteration": 1672983005672, + "id": 14, + "iteration": 1682063040196, "links": [ { "asDropdown": false, @@ -1027,5 +1027,5 @@ "timezone": "", "title": "Jira", "uid": "F5vqBQl7z", - "version": 2 + "version": 3 } \ No newline at end of file diff --git a/grafana/dashboards/Sonarqube.json b/grafana/dashboards/Sonarqube.json index 66ebd3f44..f411f64a6 100644 --- a/grafana/dashboards/Sonarqube.json +++ b/grafana/dashboards/Sonarqube.json @@ -15,8 +15,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 2, - "iteration": 1678275507113, + "id": 29, + "iteration": 1682063057579, "links": [], "panels": [ { @@ -927,7 +927,7 @@ { "allValue": null, "current": { - "selected": false, + "selected": true, "text": [ "All" ], @@ -955,7 +955,7 @@ { "allValue": null, "current": { - "selected": false, + "selected": true, "text": [ "All" ], @@ -983,7 +983,7 @@ { "allValue": null, "current": { - "selected": false, + "selected": true, "text": [ "All" ], @@ -1054,5 +1054,5 @@ "timezone": "", "title": "SonarQube", "uid": "WA0qbuJ4k", - "version": 5 + "version": 1 } \ No newline at end of file diff --git a/grafana/dashboards/TAPD.json b/grafana/dashboards/TAPD.json index f45c396dd..cef23ebb7 100644 --- a/grafana/dashboards/TAPD.json +++ b/grafana/dashboards/TAPD.json @@ -15,8 +15,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 22, - "iteration": 1672982963558, + "id": 16, + "iteration": 1682063068647, "links": [ { "asDropdown": false, diff --git a/grafana/dashboards/WeeklyCommunityRetro.json b/grafana/dashboards/WeeklyCommunityRetro.json index 175700918..d219c91f3 100644 --- a/grafana/dashboards/WeeklyCommunityRetro.json +++ b/grafana/dashboards/WeeklyCommunityRetro.json @@ -15,8 +15,8 @@ "editable": true, "gnetId": null, "graphTooltip": 0, - "id": 9, - "iteration": 1660821905109, + "id": 27, + "iteration": 1682063086384, "links": [], "panels": [ { @@ -1790,5 +1790,5 @@ "timezone": "", "title": "Weekly Community Retro", "uid": "VTr6Y_q7z", - "version": 7 + "version": 3 } \ No newline at end of file
