You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by zk...@apache.org on 2022/07/25 14:31:47 UTC
[incubator-devlake] branch main updated: feat: add description for all dashboards (#2597)
This is an automated email from the ASF dual-hosted git repository.
zky pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/main by this push:
new 9f5ad6e3 feat: add description for all dashboards (#2597)
9f5ad6e3 is described below
commit 9f5ad6e35fbe85f5b77b0933fd1f299d73c9fbe3
Author: Louis.z <lo...@gmail.com>
AuthorDate: Mon Jul 25 22:31:43 2022 +0800
feat: add description for all dashboards (#2597)
Co-authored-by: Startrekzky <ka...@merico.dev>
---
grafana/dashboards/EngineeringOverview.json | 77 +++++++++++++--------
.../EngineeringThroughputAndCycleTime.json | 57 +++++++++++-----
.../EngineeringThroughputAndCycleTimeTeamView.json | 61 ++++++++++++-----
.../{GithubBasicMetrics.json => GitHub.json} | 77 +++++++++++++--------
...ithubReleaseQualityAndContributionAnalysis.json | 79 ++++++++++++++--------
grafana/dashboards/Gitlab.json | 57 +++++++++++-----
grafana/dashboards/Jenkins.json | 43 +++++++++---
grafana/dashboards/Jira.json | 53 +++++++++++----
grafana/dashboards/WeeklyBugRetro.json | 57 +++++++++++-----
grafana/dashboards/WeeklyCommunityRetro.json | 78 +++++++++++++--------
10 files changed, 436 insertions(+), 203 deletions(-)
diff --git a/grafana/dashboards/EngineeringOverview.json b/grafana/dashboards/EngineeringOverview.json
index 21bb562c..f56de168 100644
--- a/grafana/dashboards/EngineeringOverview.json
+++ b/grafana/dashboards/EngineeringOverview.json
@@ -15,10 +15,33 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 12,
- "iteration": 1658734029836,
+ "id": 17,
+ "iteration": 1658758283524,
"links": [],
"panels": [
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 3,
+ "w": 13,
+ "x": 0,
+ "y": 0
+ },
+ "id": 32,
+ "options": {
+ "content": "- Use Cases: This dashboard is to overview the Git and project management metrics.\n- Data Source Required: Jira + GitHub, or Jira + GitLab.",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "title": "Dashboard Introduction",
+ "type": "text"
+ },
{
"datasource": "mysql",
"fieldConfig": {
@@ -51,7 +74,7 @@
"h": 8,
"w": 6,
"x": 0,
- "y": 0
+ "y": 3
},
"id": 8,
"options": {
@@ -145,7 +168,7 @@
"h": 8,
"w": 18,
"x": 6,
- "y": 0
+ "y": 3
},
"id": 22,
"options": {
@@ -230,7 +253,7 @@
"h": 8,
"w": 6,
"x": 0,
- "y": 8
+ "y": 11
},
"id": 10,
"options": {
@@ -336,7 +359,7 @@
}
]
},
- "unit": "d"
+ "unit": "none"
},
"overrides": []
},
@@ -344,7 +367,7 @@
"h": 8,
"w": 18,
"x": 6,
- "y": 8
+ "y": 11
},
"id": 23,
"options": {
@@ -424,7 +447,7 @@
"h": 8,
"w": 6,
"x": 0,
- "y": 16
+ "y": 19
},
"id": 14,
"options": {
@@ -518,7 +541,7 @@
"h": 8,
"w": 18,
"x": 6,
- "y": 16
+ "y": 19
},
"id": 24,
"options": {
@@ -607,7 +630,7 @@
"h": 8,
"w": 6,
"x": 0,
- "y": 24
+ "y": 27
},
"id": 6,
"options": {
@@ -718,7 +741,7 @@
"h": 8,
"w": 18,
"x": 6,
- "y": 24
+ "y": 27
},
"id": 25,
"options": {
@@ -795,7 +818,7 @@
"h": 8,
"w": 6,
"x": 0,
- "y": 32
+ "y": 35
},
"id": 4,
"options": {
@@ -890,7 +913,7 @@
"h": 8,
"w": 18,
"x": 6,
- "y": 32
+ "y": 35
},
"id": 26,
"options": {
@@ -978,7 +1001,7 @@
"h": 8,
"w": 6,
"x": 0,
- "y": 40
+ "y": 43
},
"id": 16,
"options": {
@@ -1088,7 +1111,7 @@
"h": 8,
"w": 18,
"x": 6,
- "y": 40
+ "y": 43
},
"id": 28,
"options": {
@@ -1165,7 +1188,7 @@
"h": 8,
"w": 6,
"x": 0,
- "y": 48
+ "y": 51
},
"id": 12,
"options": {
@@ -1275,7 +1298,7 @@
"h": 8,
"w": 18,
"x": 6,
- "y": 48
+ "y": 51
},
"id": 29,
"options": {
@@ -1354,7 +1377,7 @@
"h": 8,
"w": 6,
"x": 0,
- "y": 56
+ "y": 59
},
"id": 2,
"options": {
@@ -1466,7 +1489,7 @@
"h": 8,
"w": 18,
"x": 6,
- "y": 56
+ "y": 59
},
"id": 30,
"options": {
@@ -1487,7 +1510,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n DATE_ADD(date(pr.created_date), INTERVAL -DAY(date(pr.created_date))+1 DAY) as time,\n AVG(TIMESTAMPDIFF(MINUTE, pr.created_date, pr.merged_date) / 1440) as pr_cycle_time_in_days\nfrom\n lake.pull_requests pr\nwhere\n pr.merged_date is not null\n and pr.base_repo_id in ($repo_id)\n and $__timeFilter(pr.created_date)\n and pr.created_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH)\ngroup by time",
+ "rawSql": "select\n DATE_ADD(date(pr.created_date), INTERVAL -DAY(date(pr.created_date))+1 DAY) as time,\n AVG(TIMESTAMPDIFF(MINUTE, pr.created_date, pr.merged_date) / 1440) as pr_cycle_time_in_days\nfrom\n lake.pull_requests pr\nwhere\n pr.merged_date is not null\n and pr.base_repo_id in ($repo_id)\n and $__timeFilter(pr.created_date)\n and pr.created_date >= DATE_ADD(DATE_ADD($__timeFrom(), INTERVAL -DAY($__timeFrom())+1 DAY), INTERVAL +1 MONTH)\ngroup by time\norder b [...]
"refId": "A",
"select": [
[
@@ -1556,7 +1579,7 @@
"h": 8,
"w": 12,
"x": 0,
- "y": 64
+ "y": 67
},
"id": 20,
"options": {
@@ -1607,7 +1630,7 @@
]
}
],
- "title": "Average Age of Critical Outstanding Defects by Severity",
+ "title": "Average Age of Critical Outstanding Defects by Priority",
"type": "barchart"
},
{
@@ -1632,7 +1655,7 @@
"h": 8,
"w": 12,
"x": 12,
- "y": 64
+ "y": 67
},
"id": 21,
"options": {
@@ -1667,7 +1690,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n sum(case when type = 'BUG' then 1 else 0 end) as 'Bug',\n sum(case when type != 'BUG' and epic_key != '' then 1 else 0 end) as 'Strategic',\n sum(case when type != 'BUG' and epic_key = '' then 1 else 0 end) as 'Non-Strategic'\nfrom\n issues\nwhere\n resolution_date is not null and\n date(resolution_date) between\n STR_TO_DATE('$month','%Y-%m-%d') and\n STR_TO_DATE('$month','%Y-%m-%d') + INTERVAL 1 MONTH - INTERVAL 1 DAY",
+ "rawSql": "select\n sum(case when type = 'BUG' then 1 else 0 end) as 'Bug',\n sum(case when type = 'BUG' and epic_key != '' then 1 else 0 end) as 'Strategic',\n sum(case when type != 'BUG' and epic_key = '' then 1 else 0 end) as 'Non-Strategic'\nfrom\n issues\nwhere\n resolution_date is not null and\n date(resolution_date) between\n STR_TO_DATE('$month','%Y-%m-%d') and\n STR_TO_DATE('$month','%Y-%m-%d') + INTERVAL 1 MONTH - INTERVAL 1 DAY",
"refId": "A",
"select": [
[
@@ -1704,7 +1727,7 @@
{
"allValue": null,
"current": {
- "selected": true,
+ "selected": false,
"text": "All",
"value": "$__all"
},
@@ -1728,7 +1751,7 @@
{
"allValue": null,
"current": {
- "selected": true,
+ "selected": false,
"text": "2022-06",
"value": "2022-06-01"
},
@@ -1845,5 +1868,5 @@
"timezone": "",
"title": "Engineering Overview",
"uid": "ZF6abXX7z",
- "version": 1
+ "version": 8
}
\ No newline at end of file
diff --git a/grafana/dashboards/EngineeringThroughputAndCycleTime.json b/grafana/dashboards/EngineeringThroughputAndCycleTime.json
index 6e08d767..cf838156 100644
--- a/grafana/dashboards/EngineeringThroughputAndCycleTime.json
+++ b/grafana/dashboards/EngineeringThroughputAndCycleTime.json
@@ -15,10 +15,33 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 15,
- "iteration": 1657889619666,
+ "id": 12,
+ "iteration": 1658758247771,
"links": [],
"panels": [
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 3,
+ "w": 13,
+ "x": 0,
+ "y": 0
+ },
+ "id": 111,
+ "options": {
+ "content": "- Use Cases: This dashboard shows the engineering throughput and and cycle time, which helps to identify productivity and bottlenecks of the development process.\n- Data Source Required: GitHub and Jira([transformation](https://devlake.apache.org/docs/UserManuals/ConfigUI/Jira#step-3---adding-transformation-rules-optional) required to tell DevLake what the story_points field is)",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "title": "Dashboard Introduction",
+ "type": "text"
+ },
{
"collapsed": false,
"datasource": null,
@@ -26,7 +49,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 0
+ "y": 3
},
"id": 89,
"panels": [],
@@ -121,7 +144,7 @@
"h": 7,
"w": 8,
"x": 0,
- "y": 1
+ "y": 4
},
"id": 79,
"options": {
@@ -259,7 +282,7 @@
"h": 7,
"w": 8,
"x": 8,
- "y": 1
+ "y": 4
},
"id": 74,
"options": {
@@ -366,7 +389,7 @@
"h": 7,
"w": 8,
"x": 16,
- "y": 1
+ "y": 4
},
"id": 98,
"options": {
@@ -473,7 +496,7 @@
"h": 7,
"w": 8,
"x": 0,
- "y": 8
+ "y": 11
},
"id": 99,
"options": {
@@ -581,7 +604,7 @@
"h": 7,
"w": 8,
"x": 8,
- "y": 8
+ "y": 11
},
"id": 100,
"options": {
@@ -688,7 +711,7 @@
"h": 7,
"w": 8,
"x": 16,
- "y": 8
+ "y": 11
},
"id": 101,
"options": {
@@ -745,7 +768,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 15
+ "y": 18
},
"id": 103,
"panels": [],
@@ -837,7 +860,7 @@
"h": 7,
"w": 24,
"x": 0,
- "y": 16
+ "y": 19
},
"id": 109,
"options": {
@@ -941,7 +964,7 @@
"h": 7,
"w": 8,
"x": 0,
- "y": 23
+ "y": 26
},
"id": 104,
"options": {
@@ -1076,7 +1099,7 @@
"h": 7,
"w": 8,
"x": 8,
- "y": 23
+ "y": 26
},
"id": 105,
"options": {
@@ -1211,7 +1234,7 @@
"h": 7,
"w": 8,
"x": 16,
- "y": 23
+ "y": 26
},
"id": 107,
"options": {
@@ -1315,7 +1338,7 @@
"h": 7,
"w": 8,
"x": 0,
- "y": 30
+ "y": 33
},
"id": 108,
"options": {
@@ -1338,7 +1361,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL -$interval(date(created_date))+1 DAY) as time,\n sum(case when id not in (SELECT pull_request_id FROM pull_request_comments) then 1 else 0 end) as \"PRs Merged w/o Review\"\nFROM \n pull_requests\nWHERE\n $__timeFilter(created_date)\n and base_repo_id in ($repo_id)\n and merged_date is not null\nGROUP BY 1",
+ "rawSql": "SELECT\n DATE_ADD(date(created_date), INTERVAL -$interval(date(created_date))+1 DAY) as time,\n sum(case when id not in (SELECT pull_request_id FROM pull_request_comments) then 1 else 0 end) as \"PRs Merged w/o Review\"\nFROM \n pull_requests\nWHERE\n $__timeFilter(created_date)\n and base_repo_id in ($repo_id)\n and merged_date is not null\nGROUP BY 1\nORDER BY 1",
"refId": "A",
"select": [
[
@@ -1528,5 +1551,5 @@
"timezone": "",
"title": "Engineering Throughput and Cycle Time",
"uid": "Jaaimc67k",
- "version": 19
+ "version": 5
}
\ No newline at end of file
diff --git a/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json b/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
index 9a1d4895..094760fb 100644
--- a/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
+++ b/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
@@ -15,10 +15,33 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 16,
- "iteration": 1658114695221,
+ "id": 1,
+ "iteration": 1658758034209,
"links": [],
"panels": [
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 3,
+ "w": 13,
+ "x": 0,
+ "y": 0
+ },
+ "id": 142,
+ "options": {
+ "content": "- Use Cases: This dashboard shows the engineering throughput and and cycle time, which helps to identify productivity and bottlenecks of the development process.\n- Data Source Required: GitHub and Jira([transformation](https://devlake.apache.org/docs/UserManuals/ConfigUI/Jira#step-3---adding-transformation-rules-optional) required to tell DevLake what the story_points field is). You also need to do [team configuration](https://devlake.apache.org/docs/UserManuals/Team [...]
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "title": "Dashboard Introduction",
+ "type": "text"
+ },
{
"collapsed": false,
"datasource": null,
@@ -26,7 +49,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 0
+ "y": 3
},
"id": 89,
"panels": [],
@@ -121,7 +144,7 @@
"h": 7,
"w": 12,
"x": 0,
- "y": 1
+ "y": 4
},
"id": 111,
"options": {
@@ -259,7 +282,7 @@
"h": 7,
"w": 12,
"x": 12,
- "y": 1
+ "y": 4
},
"id": 110,
"options": {
@@ -397,7 +420,7 @@
"h": 7,
"w": 12,
"x": 0,
- "y": 8
+ "y": 11
},
"id": 79,
"options": {
@@ -535,7 +558,7 @@
"h": 7,
"w": 12,
"x": 12,
- "y": 8
+ "y": 11
},
"id": 112,
"options": {
@@ -592,7 +615,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 15
+ "y": 18
},
"id": 114,
"panels": [
@@ -883,7 +906,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 16
+ "y": 19
},
"id": 126,
"panels": [
@@ -1174,7 +1197,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 17
+ "y": 20
},
"id": 124,
"panels": [
@@ -1465,7 +1488,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 18
+ "y": 21
},
"id": 119,
"panels": [
@@ -1756,7 +1779,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 19
+ "y": 22
},
"id": 103,
"panels": [
@@ -2311,7 +2334,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 20
+ "y": 23
},
"id": 139,
"panels": [
@@ -2464,9 +2487,10 @@
{
"allValue": "",
"current": {
+ "isNone": true,
"selected": false,
- "text": "DevLake",
- "value": "1"
+ "text": "None",
+ "value": ""
},
"datasource": "mysql",
"definition": "select concat(name, '--', id) as text from teams",
@@ -2488,9 +2512,10 @@
{
"allValue": "",
"current": {
+ "isNone": true,
"selected": false,
- "text": "DevStream",
- "value": "2"
+ "text": "None",
+ "value": ""
},
"datasource": "mysql",
"definition": "select concat(name, '--', id) as text from teams",
@@ -2665,5 +2690,5 @@
"timezone": "",
"title": "Engineering Throughput and Cycle Time - Team View",
"uid": "nJ1ijje7k",
- "version": 88
+ "version": 2
}
\ No newline at end of file
diff --git a/grafana/dashboards/GithubBasicMetrics.json b/grafana/dashboards/GitHub.json
similarity index 98%
rename from grafana/dashboards/GithubBasicMetrics.json
rename to grafana/dashboards/GitHub.json
index e7e1b8c5..b3087477 100644
--- a/grafana/dashboards/GithubBasicMetrics.json
+++ b/grafana/dashboards/GitHub.json
@@ -15,10 +15,33 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 13,
- "iteration": 1658298341844,
+ "id": 2,
+ "iteration": 1658758592543,
"links": [],
"panels": [
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 3,
+ "w": 13,
+ "x": 0,
+ "y": 0
+ },
+ "id": 99,
+ "options": {
+ "content": "- Use Cases: This dashboard shows the basic Git and Code Reivew metrics from GitHub.\n- Data Source Required: GitHub",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "title": "Dashboard Introduction",
+ "type": "text"
+ },
{
"collapsed": false,
"datasource": null,
@@ -26,7 +49,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 0
+ "y": 3
},
"id": 89,
"panels": [],
@@ -62,7 +85,7 @@
"h": 6,
"w": 7,
"x": 0,
- "y": 1
+ "y": 4
},
"id": 62,
"options": {
@@ -157,7 +180,7 @@
"h": 6,
"w": 17,
"x": 7,
- "y": 1
+ "y": 4
},
"id": 74,
"options": {
@@ -221,7 +244,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 7
+ "y": 10
},
"id": 87,
"panels": [],
@@ -257,7 +280,7 @@
"h": 6,
"w": 7,
"x": 0,
- "y": 8
+ "y": 11
},
"id": 43,
"options": {
@@ -383,7 +406,7 @@
"h": 6,
"w": 17,
"x": 7,
- "y": 8
+ "y": 11
},
"id": 76,
"options": {
@@ -462,7 +485,7 @@
"h": 6,
"w": 7,
"x": 0,
- "y": 14
+ "y": 17
},
"id": 64,
"options": {
@@ -557,7 +580,7 @@
"h": 6,
"w": 17,
"x": 7,
- "y": 14
+ "y": 17
},
"id": 75,
"options": {
@@ -655,7 +678,7 @@
"h": 6,
"w": 24,
"x": 0,
- "y": 20
+ "y": 23
},
"id": 93,
"options": {
@@ -835,7 +858,7 @@
"h": 6,
"w": 24,
"x": 0,
- "y": 26
+ "y": 29
},
"id": 92,
"options": {
@@ -884,7 +907,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 32
+ "y": 35
},
"id": 83,
"panels": [],
@@ -920,7 +943,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 33
+ "y": 36
},
"id": 68,
"options": {
@@ -1015,7 +1038,7 @@
"h": 6,
"w": 18,
"x": 6,
- "y": 33
+ "y": 36
},
"id": 77,
"options": {
@@ -1113,7 +1136,7 @@
"h": 6,
"w": 24,
"x": 0,
- "y": 39
+ "y": 42
},
"id": 59,
"options": {
@@ -1175,7 +1198,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 45
+ "y": 48
},
"id": 85,
"panels": [],
@@ -1212,7 +1235,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 46
+ "y": 49
},
"id": 66,
"options": {
@@ -1316,7 +1339,7 @@
"h": 6,
"w": 18,
"x": 6,
- "y": 46
+ "y": 49
},
"id": 79,
"options": {
@@ -1395,7 +1418,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 52
+ "y": 55
},
"id": 80,
"options": {
@@ -1505,7 +1528,7 @@
"h": 6,
"w": 18,
"x": 6,
- "y": 52
+ "y": 55
},
"id": 81,
"options": {
@@ -1582,7 +1605,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 58
+ "y": 61
},
"id": 72,
"options": {
@@ -1677,7 +1700,7 @@
"h": 6,
"w": 18,
"x": 6,
- "y": 58
+ "y": 61
},
"id": 95,
"options": {
@@ -1761,7 +1784,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 64
+ "y": 67
},
"id": 96,
"options": {
@@ -1854,7 +1877,7 @@
"h": 6,
"w": 18,
"x": 6,
- "y": 64
+ "y": 67
},
"id": 97,
"options": {
@@ -1952,7 +1975,7 @@
},
"timepicker": {},
"timezone": "",
- "title": "Github_Basic_Metrics",
+ "title": "GitHub",
"uid": "KXWvOFQnz",
- "version": 4
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
index c9b28b7b..b4ca88b0 100644
--- a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
+++ b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
@@ -15,10 +15,33 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 15,
- "iteration": 1658723594192,
+ "id": 13,
+ "iteration": 1658758698345,
"links": [],
"panels": [
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 3,
+ "w": 13,
+ "x": 0,
+ "y": 0
+ },
+ "id": 57,
+ "options": {
+ "content": "- Use Cases: This dashboard can be used to track bugs.\n- Data Source Required: GitHub ([transformation](https://devlake.apache.org/docs/UserManuals/ConfigUI/GitHub#step-3---adding-transformation-rules-optional) required. Additional settings are required to get version data).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "title": "Dashboard Introduction",
+ "type": "text"
+ },
{
"collapsed": false,
"datasource": null,
@@ -26,7 +49,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 0
+ "y": 3
},
"id": 45,
"panels": [],
@@ -57,7 +80,7 @@
"h": 7,
"w": 7,
"x": 0,
- "y": 1
+ "y": 4
},
"id": 15,
"options": {
@@ -192,7 +215,7 @@
"h": 7,
"w": 17,
"x": 7,
- "y": 1
+ "y": 4
},
"id": 29,
"options": {
@@ -269,7 +292,7 @@
"h": 7,
"w": 8,
"x": 0,
- "y": 8
+ "y": 11
},
"id": 55,
"options": {
@@ -424,7 +447,7 @@
"h": 7,
"w": 8,
"x": 8,
- "y": 8
+ "y": 11
},
"id": 53,
"options": {
@@ -509,7 +532,7 @@
"h": 7,
"w": 8,
"x": 16,
- "y": 8
+ "y": 11
},
"id": 51,
"options": {
@@ -690,7 +713,7 @@
"h": 7,
"w": 24,
"x": 0,
- "y": 15
+ "y": 18
},
"id": 43,
"options": {
@@ -756,7 +779,7 @@
"h": 7,
"w": 11,
"x": 0,
- "y": 22
+ "y": 25
},
"id": 30,
"options": {
@@ -842,7 +865,7 @@
"h": 7,
"w": 13,
"x": 11,
- "y": 22
+ "y": 25
},
"id": 31,
"options": {
@@ -938,7 +961,7 @@
"h": 7,
"w": 6,
"x": 0,
- "y": 29
+ "y": 32
},
"id": 23,
"options": {
@@ -1034,7 +1057,7 @@
"h": 7,
"w": 18,
"x": 6,
- "y": 29
+ "y": 32
},
"id": 18,
"options": {
@@ -1118,7 +1141,7 @@
"h": 6,
"w": 4,
"x": 0,
- "y": 36
+ "y": 39
},
"id": 33,
"options": {
@@ -1214,7 +1237,7 @@
"h": 6,
"w": 20,
"x": 4,
- "y": 36
+ "y": 39
},
"id": 32,
"options": {
@@ -1298,7 +1321,7 @@
"h": 6,
"w": 4,
"x": 0,
- "y": 42
+ "y": 45
},
"id": 34,
"options": {
@@ -1470,7 +1493,7 @@
"h": 6,
"w": 20,
"x": 4,
- "y": 42
+ "y": 45
},
"id": 38,
"options": {
@@ -1591,7 +1614,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 48
+ "y": 51
},
"id": 35,
"options": {
@@ -1767,7 +1790,7 @@
"h": 6,
"w": 18,
"x": 6,
- "y": 48
+ "y": 51
},
"id": 39,
"options": {
@@ -1816,7 +1839,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 54
+ "y": 57
},
"id": 47,
"panels": [],
@@ -1864,7 +1887,7 @@
"h": 7,
"w": 6,
"x": 0,
- "y": 55
+ "y": 58
},
"id": 41,
"options": {
@@ -1986,7 +2009,7 @@
"h": 7,
"w": 18,
"x": 6,
- "y": 55
+ "y": 58
},
"id": 42,
"options": {
@@ -2081,7 +2104,7 @@
"h": 7,
"w": 8,
"x": 0,
- "y": 62
+ "y": 65
},
"id": 26,
"options": {
@@ -2197,7 +2220,7 @@
"h": 7,
"w": 8,
"x": 8,
- "y": 62
+ "y": 65
},
"id": 36,
"options": {
@@ -2313,7 +2336,7 @@
"h": 7,
"w": 8,
"x": 16,
- "y": 62
+ "y": 65
},
"id": 37,
"options": {
@@ -2409,7 +2432,7 @@
"h": 7,
"w": 6,
"x": 0,
- "y": 69
+ "y": 72
},
"id": 27,
"options": {
@@ -2504,7 +2527,7 @@
"h": 7,
"w": 18,
"x": 6,
- "y": 69
+ "y": 72
},
"id": 3,
"options": {
@@ -2601,5 +2624,5 @@
"timezone": "",
"title": "GitHub_Release_Quality_and_Contribution_Analysis",
"uid": "2xuOaQUnk4",
- "version": 3
+ "version": 2
}
\ No newline at end of file
diff --git a/grafana/dashboards/Gitlab.json b/grafana/dashboards/Gitlab.json
index c548615d..74b180c8 100644
--- a/grafana/dashboards/Gitlab.json
+++ b/grafana/dashboards/Gitlab.json
@@ -16,9 +16,32 @@
"gnetId": null,
"graphTooltip": 0,
"id": 14,
- "iteration": 1654502158744,
+ "iteration": 1658758604733,
"links": [],
"panels": [
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 3,
+ "w": 13,
+ "x": 0,
+ "y": 0
+ },
+ "id": 101,
+ "options": {
+ "content": "- Use Cases: This dashboard shows the basic Git and Code Reivew metrics from GitLab.\n- Data Source Required: GitLab",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "title": "Dashboard Introduction",
+ "type": "text"
+ },
{
"collapsed": false,
"datasource": null,
@@ -26,7 +49,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 0
+ "y": 3
},
"id": 83,
"panels": [],
@@ -62,7 +85,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 1
+ "y": 4
},
"id": 68,
"options": {
@@ -157,7 +180,7 @@
"h": 6,
"w": 18,
"x": 6,
- "y": 1
+ "y": 4
},
"id": 77,
"options": {
@@ -255,7 +278,7 @@
"h": 6,
"w": 24,
"x": 0,
- "y": 7
+ "y": 10
},
"id": 59,
"options": {
@@ -317,7 +340,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 13
+ "y": 16
},
"id": 85,
"panels": [],
@@ -354,7 +377,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 14
+ "y": 17
},
"id": 66,
"options": {
@@ -458,7 +481,7 @@
"h": 6,
"w": 18,
"x": 6,
- "y": 14
+ "y": 17
},
"id": 79,
"options": {
@@ -537,7 +560,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 20
+ "y": 23
},
"id": 80,
"options": {
@@ -647,7 +670,7 @@
"h": 6,
"w": 18,
"x": 6,
- "y": 20
+ "y": 23
},
"id": 81,
"options": {
@@ -726,7 +749,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 26
+ "y": 29
},
"id": 72,
"options": {
@@ -821,7 +844,7 @@
"h": 6,
"w": 18,
"x": 6,
- "y": 26
+ "y": 29
},
"id": 95,
"options": {
@@ -905,7 +928,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 32
+ "y": 35
},
"id": 96,
"options": {
@@ -998,7 +1021,7 @@
"h": 6,
"w": 18,
"x": 6,
- "y": 32
+ "y": 35
},
"id": 97,
"options": {
@@ -1059,7 +1082,7 @@
"h": 3,
"w": 24,
"x": 0,
- "y": 38
+ "y": 41
},
"id": 99,
"options": {
@@ -1118,7 +1141,7 @@
},
"timepicker": {},
"timezone": "",
- "title": "Gitlab",
+ "title": "GitLab",
"uid": "msSjEq97z",
- "version": 12
+ "version": 4
}
\ No newline at end of file
diff --git a/grafana/dashboards/Jenkins.json b/grafana/dashboards/Jenkins.json
index a8550e0f..f2e13c1f 100644
--- a/grafana/dashboards/Jenkins.json
+++ b/grafana/dashboards/Jenkins.json
@@ -15,10 +15,33 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 12,
- "iteration": 1650627258965,
+ "id": 7,
+ "iteration": 1658757686977,
"links": [],
"panels": [
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 3,
+ "w": 24,
+ "x": 0,
+ "y": 0
+ },
+ "id": 58,
+ "options": {
+ "content": "- Use Cases: This dashboard shows the basic CI/CD metrics from Jenkins.\n- Data Source Required: Jenkins",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "title": "Dashboard Introduction",
+ "type": "text"
+ },
{
"datasource": "mysql",
"description": "Number of builds executed in the selected time range",
@@ -41,7 +64,7 @@
"h": 6,
"w": 6,
"x": 0,
- "y": 0
+ "y": 3
},
"id": 4,
"options": {
@@ -120,7 +143,7 @@
"h": 6,
"w": 6,
"x": 6,
- "y": 0
+ "y": 3
},
"id": 6,
"options": {
@@ -225,7 +248,7 @@
"h": 6,
"w": 6,
"x": 12,
- "y": 0
+ "y": 3
},
"id": 37,
"interval": null,
@@ -317,7 +340,7 @@
"h": 6,
"w": 6,
"x": 18,
- "y": 0
+ "y": 3
},
"id": 55,
"options": {
@@ -411,7 +434,7 @@
"h": 6,
"w": 12,
"x": 0,
- "y": 6
+ "y": 9
},
"id": 52,
"options": {
@@ -525,7 +548,7 @@
"h": 6,
"w": 12,
"x": 12,
- "y": 6
+ "y": 9
},
"id": 50,
"interval": "",
@@ -672,7 +695,7 @@
"h": 6,
"w": 24,
"x": 0,
- "y": 12
+ "y": 15
},
"id": 54,
"options": {
@@ -780,7 +803,7 @@
"h": 6,
"w": 24,
"x": 0,
- "y": 18
+ "y": 21
},
"id": 56,
"options": {
diff --git a/grafana/dashboards/Jira.json b/grafana/dashboards/Jira.json
index 793a81b4..5fe5d0c1 100644
--- a/grafana/dashboards/Jira.json
+++ b/grafana/dashboards/Jira.json
@@ -15,8 +15,8 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 12,
- "iteration": 1652286394084,
+ "id": 8,
+ "iteration": 1658757165613,
"links": [
{
"asDropdown": false,
@@ -46,13 +46,36 @@
}
],
"panels": [
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 3,
+ "w": 13,
+ "x": 0,
+ "y": 0
+ },
+ "id": 128,
+ "options": {
+ "content": "- Use Cases: This dashboard shows the basic project management metrics from Jira.\n- Data Source Required: Jira",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "title": "Dashboard Introduction",
+ "type": "text"
+ },
{
"datasource": null,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
- "y": 0
+ "y": 3
},
"id": 126,
"title": "1. Issue Throughput",
@@ -83,7 +106,7 @@
"h": 6,
"w": 4,
"x": 0,
- "y": 1
+ "y": 4
},
"id": 114,
"options": {
@@ -160,7 +183,7 @@
"h": 6,
"w": 4,
"x": 4,
- "y": 1
+ "y": 4
},
"id": 116,
"options": {
@@ -269,7 +292,7 @@
"h": 6,
"w": 16,
"x": 8,
- "y": 1
+ "y": 4
},
"id": 120,
"interval": null,
@@ -350,7 +373,7 @@
"h": 6,
"w": 8,
"x": 0,
- "y": 7
+ "y": 10
},
"id": 117,
"options": {
@@ -460,7 +483,7 @@
"h": 6,
"w": 16,
"x": 8,
- "y": 7
+ "y": 10
},
"id": 121,
"links": [],
@@ -516,7 +539,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 13
+ "y": 16
},
"id": 110,
"panels": [],
@@ -550,7 +573,7 @@
"h": 6,
"w": 4,
"x": 0,
- "y": 14
+ "y": 17
},
"id": 12,
"options": {
@@ -630,7 +653,7 @@
"h": 6,
"w": 4,
"x": 4,
- "y": 14
+ "y": 17
},
"id": 13,
"options": {
@@ -727,7 +750,7 @@
"h": 6,
"w": 16,
"x": 8,
- "y": 14
+ "y": 17
},
"id": 17,
"interval": "",
@@ -797,7 +820,7 @@
"h": 6,
"w": 24,
"x": 0,
- "y": 20
+ "y": 23
},
"hiddenSeries": false,
"id": 15,
@@ -982,5 +1005,5 @@
"timezone": "",
"title": "Jira",
"uid": "F5vqBQl7z",
- "version": 65
-}
+ "version": 4
+}
\ No newline at end of file
diff --git a/grafana/dashboards/WeeklyBugRetro.json b/grafana/dashboards/WeeklyBugRetro.json
index e6940ed8..6be6f14e 100644
--- a/grafana/dashboards/WeeklyBugRetro.json
+++ b/grafana/dashboards/WeeklyBugRetro.json
@@ -15,10 +15,33 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 8,
- "iteration": 1658722995471,
+ "id": 15,
+ "iteration": 1658757077334,
"links": [],
"panels": [
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 3,
+ "w": 13,
+ "x": 0,
+ "y": 0
+ },
+ "id": 28,
+ "options": {
+ "content": "- Use Cases: This dashboard can be used to track bugs.\n- Data Source Required: GitHub ([transformation](https://devlake.apache.org/docs/UserManuals/ConfigUI/GitHub#step-3---adding-transformation-rules-optional) required) or Jira ([transformation](https://devlake.apache.org/docs/UserManuals/ConfigUI/Jira#step-3---adding-transformation-rules-optional) required). Transformation is the configuration for you to tell DevLake what is a bug.",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "title": "Dashboard Introduction",
+ "type": "text"
+ },
{
"datasource": "mysql",
"fieldConfig": {
@@ -47,7 +70,7 @@
"h": 8,
"w": 6,
"x": 0,
- "y": 0
+ "y": 3
},
"id": 6,
"options": {
@@ -122,7 +145,7 @@
"h": 8,
"w": 6,
"x": 6,
- "y": 0
+ "y": 3
},
"id": 26,
"options": {
@@ -293,7 +316,7 @@
"h": 8,
"w": 12,
"x": 12,
- "y": 0
+ "y": 3
},
"id": 4,
"options": {
@@ -363,7 +386,7 @@
"h": 8,
"w": 6,
"x": 0,
- "y": 8
+ "y": 11
},
"id": 8,
"options": {
@@ -449,7 +472,7 @@
"h": 8,
"w": 6,
"x": 6,
- "y": 8
+ "y": 11
},
"id": 24,
"options": {
@@ -601,7 +624,7 @@
"h": 16,
"w": 12,
"x": 12,
- "y": 8
+ "y": 11
},
"id": 10,
"options": {
@@ -685,7 +708,7 @@
"h": 8,
"w": 12,
"x": 0,
- "y": 16
+ "y": 19
},
"id": 23,
"options": {
@@ -768,7 +791,7 @@
"h": 9,
"w": 6,
"x": 0,
- "y": 24
+ "y": 27
},
"id": 16,
"options": {
@@ -849,7 +872,7 @@
"h": 9,
"w": 6,
"x": 6,
- "y": 24
+ "y": 27
},
"id": 25,
"options": {
@@ -1025,7 +1048,7 @@
"h": 18,
"w": 12,
"x": 12,
- "y": 24
+ "y": 27
},
"id": 14,
"options": {
@@ -1108,7 +1131,7 @@
"h": 9,
"w": 12,
"x": 0,
- "y": 33
+ "y": 36
},
"id": 18,
"options": {
@@ -1204,7 +1227,7 @@
"h": 9,
"w": 24,
"x": 0,
- "y": 42
+ "y": 45
},
"id": 2,
"options": {
@@ -1299,7 +1322,7 @@
"h": 10,
"w": 24,
"x": 0,
- "y": 51
+ "y": 54
},
"id": 20,
"options": {
@@ -1394,7 +1417,7 @@
"h": 10,
"w": 24,
"x": 0,
- "y": 61
+ "y": 64
},
"id": 21,
"options": {
@@ -1514,5 +1537,5 @@
"timezone": "",
"title": "Weekly Bug Retro",
"uid": "-5EKA5w7k",
- "version": 3
+ "version": 2
}
\ No newline at end of file
diff --git a/grafana/dashboards/WeeklyCommunityRetro.json b/grafana/dashboards/WeeklyCommunityRetro.json
index 332db06b..6765507b 100644
--- a/grafana/dashboards/WeeklyCommunityRetro.json
+++ b/grafana/dashboards/WeeklyCommunityRetro.json
@@ -15,10 +15,33 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 17,
- "iteration": 1658414945725,
+ "id": 9,
+ "iteration": 1658758447987,
"links": [],
"panels": [
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 3,
+ "w": 13,
+ "x": 0,
+ "y": 0
+ },
+ "id": 48,
+ "options": {
+ "content": "- Use Cases: This dashboard can be used to track community growth by OSS maintainers.\n- Data Source Required: GitHub users' organizations are used to filter issues/PRs created by certain users. [Publicize users' org](https://docs.github.com/en/account-and-profile/setting-up-and-managing-your-personal-account-on-github/managing-your-membership-in-organizations/publicizing-or-hiding-organization-membership) so that Apache DevLake can collect users' org.",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "title": "Dashboard Introduction",
+ "type": "text"
+ },
{
"collapsed": false,
"datasource": null,
@@ -26,7 +49,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 0
+ "y": 3
},
"id": 42,
"panels": [],
@@ -61,7 +84,7 @@
"h": 8,
"w": 8,
"x": 0,
- "y": 1
+ "y": 4
},
"id": 6,
"options": {
@@ -142,7 +165,7 @@
"h": 8,
"w": 6,
"x": 8,
- "y": 1
+ "y": 4
},
"id": 22,
"options": {
@@ -224,7 +247,7 @@
"h": 8,
"w": 6,
"x": 14,
- "y": 1
+ "y": 4
},
"id": 23,
"options": {
@@ -309,7 +332,7 @@
"h": 8,
"w": 4,
"x": 20,
- "y": 1
+ "y": 4
},
"id": 45,
"options": {
@@ -383,7 +406,7 @@
"h": 8,
"w": 8,
"x": 0,
- "y": 9
+ "y": 12
},
"id": 24,
"options": {
@@ -529,7 +552,7 @@
"h": 8,
"w": 16,
"x": 8,
- "y": 9
+ "y": 12
},
"id": 25,
"options": {
@@ -596,7 +619,7 @@
}
]
},
- "unit": "none"
+ "unit": "d"
},
"overrides": []
},
@@ -604,7 +627,7 @@
"h": 8,
"w": 8,
"x": 0,
- "y": 17
+ "y": 20
},
"id": 26,
"options": {
@@ -630,7 +653,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with issue_comment_list as(\n select\n i.id as issue_id,\n i.url,\n i.title,\n i.created_date as issue_created_date,\n ic.id as comment_id,\n ic.created_date as comment_date,\n ic.body,\n case when ic.id is not null then rank() over (partition by i.id order by ic.created_date asc) else null end as comment_rank\n from\n issues i\n join board_issues bi on i.id = bi.issue_id\n join boards b on bi.board_id = b.id\n left join issue_co [...]
+ "rawSql": "with issue_comment_list as(\n select\n i.id as issue_id,\n i.url,\n i.title,\n i.created_date as issue_created_date,\n ic.id as comment_id,\n ic.created_date as comment_date,\n ic.body,\n case when ic.id is not null then rank() over (partition by i.id order by ic.created_date asc) else null end as comment_rank\n from\n issues i\n join board_issues bi on i.id = bi.issue_id\n join boards b on bi.board_id = b.id\n left join issue_co [...]
"refId": "A",
"select": [
[
@@ -654,7 +677,7 @@
]
}
],
- "title": "New Community Issues' Average Response Time in Hours [Previous Week]",
+ "title": "New Community Issues' Average Response Time in Days [Previous Week]",
"type": "stat"
},
{
@@ -839,7 +862,7 @@
"h": 8,
"w": 16,
"x": 8,
- "y": 17
+ "y": 20
},
"id": 28,
"options": {
@@ -888,7 +911,7 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 25
+ "y": 28
},
"id": 44,
"panels": [],
@@ -924,7 +947,7 @@
"h": 8,
"w": 8,
"x": 0,
- "y": 26
+ "y": 29
},
"id": 31,
"options": {
@@ -1006,7 +1029,7 @@
"h": 8,
"w": 6,
"x": 8,
- "y": 26
+ "y": 29
},
"id": 34,
"options": {
@@ -1088,7 +1111,7 @@
"h": 8,
"w": 6,
"x": 14,
- "y": 26
+ "y": 29
},
"id": 35,
"options": {
@@ -1174,7 +1197,7 @@
"h": 8,
"w": 4,
"x": 20,
- "y": 26
+ "y": 29
},
"id": 46,
"options": {
@@ -1244,7 +1267,7 @@
"h": 8,
"w": 8,
"x": 0,
- "y": 34
+ "y": 37
},
"id": 36,
"options": {
@@ -1331,7 +1354,7 @@
"h": 8,
"w": 8,
"x": 8,
- "y": 34
+ "y": 37
},
"id": 37,
"options": {
@@ -1405,7 +1428,8 @@
"value": 3
}
]
- }
+ },
+ "unit": "d"
},
"overrides": []
},
@@ -1413,7 +1437,7 @@
"h": 8,
"w": 8,
"x": 16,
- "y": 34
+ "y": 37
},
"id": 39,
"options": {
@@ -1509,7 +1533,7 @@
"h": 9,
"w": 12,
"x": 0,
- "y": 42
+ "y": 45
},
"id": 33,
"options": {
@@ -1594,7 +1618,7 @@
"h": 9,
"w": 12,
"x": 12,
- "y": 42
+ "y": 45
},
"id": 40,
"options": {
@@ -1685,7 +1709,7 @@
{
"allValue": null,
"current": {
- "selected": true,
+ "selected": false,
"text": "All",
"value": "$__all"
},
@@ -1744,5 +1768,5 @@
"timezone": "",
"title": "Weekly Community Retro",
"uid": "VTr6Y_q7z",
- "version": 19
+ "version": 5
}
\ No newline at end of file