You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by zh...@apache.org on 2022/08/18 12:14:57 UTC
[incubator-devlake] branch main updated: feat: add the link to Grafana guide in dashboards (#2771)
This is an automated email from the ASF dual-hosted git repository.
zhangliang2022 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 8571e06b feat: add the link to Grafana guide in dashboards (#2771)
8571e06b is described below
commit 8571e06bd33057f5ec1efd69777b3c3aa783b596
Author: Louis.z <lo...@gmail.com>
AuthorDate: Thu Aug 18 20:14:53 2022 +0800
feat: add the link to Grafana guide in dashboards (#2771)
Co-authored-by: Startrekzky <ka...@merico.dev>
---
grafana/dashboards/CommunityExperience.json | 83 ++++++--
.../DemoAverageRequirementLeadTimeByAssignee.json | 28 ++-
grafana/dashboards/DemoCommitCountByAuthor.json | 26 ++-
grafana/dashboards/DemoDetailedBugInfo.json | 26 ++-
...moHowFastDoWeRespondToCustomerRequirements.json | 28 ++-
.../DemoIsThisMonthMoreProductiveThanLast.json | 28 ++-
.../dashboards/DemoWasOurQualityImprovedOrNot.json | 28 ++-
grafana/dashboards/EngineeringOverview.json | 26 ++-
.../EngineeringThroughputAndCycleTime.json | 224 +++++++++++----------
.../EngineeringThroughputAndCycleTimeTeamView.json | 30 ++-
grafana/dashboards/GitHub.json | 26 ++-
...ithubReleaseQualityAndContributionAnalysis.json | 26 ++-
grafana/dashboards/Gitlab.json | 8 +-
grafana/dashboards/Jenkins.json | 26 ++-
grafana/dashboards/Jira.json | 26 ++-
grafana/dashboards/WeeklyBugRetro.json | 28 ++-
grafana/dashboards/WeeklyCommunityRetro.json | 28 ++-
17 files changed, 533 insertions(+), 162 deletions(-)
diff --git a/grafana/dashboards/CommunityExperience.json b/grafana/dashboards/CommunityExperience.json
index aa4b92a1..2744d8c6 100644
--- a/grafana/dashboards/CommunityExperience.json
+++ b/grafana/dashboards/CommunityExperience.json
@@ -15,10 +15,33 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 19,
- "iteration": 1659564067353,
+ "id": 18,
+ "iteration": 1660820599845,
"links": [],
"panels": [
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 4,
+ "w": 24,
+ "x": 0,
+ "y": 0
+ },
+ "id": 24,
+ "options": {
+ "content": "- Use Cases: This dashboard answers the question \"What makes a great developer experience? And how can we define and track that?\". This dashboard heavily focuses on actionability. All metrics can be deterministically improved as long as OSS maintainers invested time into them.\n- Data Source Required: GitHub",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "title": "Dashboard Introduction",
+ "type": "text"
+ },
{
"datasource": "mysql",
"fieldConfig": {
@@ -48,7 +71,7 @@
"h": 8,
"w": 6,
"x": 0,
- "y": 0
+ "y": 4
},
"id": 8,
"options": {
@@ -132,7 +155,7 @@
"h": 8,
"w": 6,
"x": 6,
- "y": 0
+ "y": 4
},
"id": 4,
"options": {
@@ -214,7 +237,7 @@
"h": 8,
"w": 6,
"x": 12,
- "y": 0
+ "y": 4
},
"id": 12,
"options": {
@@ -240,7 +263,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 lake.issues i\n join lake.board_issues bi on i.id = bi.issue_id\n join lake.boards b on bi.board_id = b.id\n lef [...]
+ "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 lake.issues i\n join lake.board_issues bi on i.id = bi.issue_id\n join lake.boards b on bi.board_id = b.id\n lef [...]
"refId": "A",
"select": [
[
@@ -295,7 +318,7 @@
"h": 8,
"w": 6,
"x": 18,
- "y": 0
+ "y": 4
},
"id": 10,
"options": {
@@ -377,7 +400,7 @@
"h": 8,
"w": 6,
"x": 0,
- "y": 8
+ "y": 12
},
"id": 16,
"options": {
@@ -459,7 +482,7 @@
"h": 8,
"w": 6,
"x": 6,
- "y": 8
+ "y": 12
},
"id": 14,
"options": {
@@ -541,7 +564,7 @@
"h": 8,
"w": 6,
"x": 12,
- "y": 8
+ "y": 12
},
"id": 18,
"options": {
@@ -567,7 +590,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "select\n 100 * sum(case when closed_date and TIMESTAMPDIFF(Minute, created_date, closed_date) / 1440 < $prrt_sla then 1 else 0 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 pr.base_repo_id in ($repo_id)\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 = 'closed'\n\tand pr.base_repo_id in ($repo_id)\n\n\n",
"refId": "A",
"select": [
[
@@ -623,7 +646,7 @@
"h": 8,
"w": 6,
"x": 18,
- "y": 8
+ "y": 12
},
"id": 20,
"options": {
@@ -675,6 +698,28 @@
],
"title": "PR Closed W/O Merging Ratio [Last Month]",
"type": "stat"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 20
+ },
+ "id": 22,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"schemaVersion": 30,
@@ -685,13 +730,9 @@
{
"allValue": null,
"current": {
- "selected": true,
- "text": [
- "All"
- ],
- "value": [
- "$__all"
- ]
+ "selected": false,
+ "text": "All",
+ "value": "$__all"
},
"datasource": "mysql",
"definition": "select concat(name, '-', id) from lake.repos",
@@ -785,6 +826,6 @@
"timepicker": {},
"timezone": "",
"title": "Community Experience",
- "uid": "MpKr-LzVz",
- "version": 2
+ "uid": "bwsP5Nz4z",
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/DemoAverageRequirementLeadTimeByAssignee.json b/grafana/dashboards/DemoAverageRequirementLeadTimeByAssignee.json
index 61cd49dd..5029eb63 100644
--- a/grafana/dashboards/DemoAverageRequirementLeadTimeByAssignee.json
+++ b/grafana/dashboards/DemoAverageRequirementLeadTimeByAssignee.json
@@ -15,7 +15,7 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 5,
+ "id": 3,
"links": [
{
"asDropdown": false,
@@ -207,6 +207,28 @@
"timeFrom": null,
"timeShift": null,
"type": "table"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 20
+ },
+ "id": 102,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"refresh": "",
@@ -224,5 +246,5 @@
"timezone": "",
"title": "Demo-Average Requirement Lead Time By Assignee",
"uid": "q27fk7cnk",
- "version": 1
-}
+ "version": 2
+}
\ No newline at end of file
diff --git a/grafana/dashboards/DemoCommitCountByAuthor.json b/grafana/dashboards/DemoCommitCountByAuthor.json
index e7d2a13e..836b7a96 100644
--- a/grafana/dashboards/DemoCommitCountByAuthor.json
+++ b/grafana/dashboards/DemoCommitCountByAuthor.json
@@ -15,7 +15,7 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 9,
+ "id": 4,
"links": [
{
"asDropdown": false,
@@ -214,6 +214,28 @@
"timeFrom": null,
"timeShift": null,
"type": "table"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 17
+ },
+ "id": 52,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"refresh": "",
@@ -231,5 +253,5 @@
"timezone": "",
"title": "Demo-Commit Count by Author",
"uid": "F0iYknc7z",
- "version": 3
+ "version": 2
}
\ No newline at end of file
diff --git a/grafana/dashboards/DemoDetailedBugInfo.json b/grafana/dashboards/DemoDetailedBugInfo.json
index c01873fe..da259853 100644
--- a/grafana/dashboards/DemoDetailedBugInfo.json
+++ b/grafana/dashboards/DemoDetailedBugInfo.json
@@ -15,7 +15,7 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 4,
+ "id": 10,
"links": [
{
"asDropdown": false,
@@ -272,6 +272,28 @@
}
],
"type": "table"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 16
+ },
+ "id": 34,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"refresh": "",
@@ -289,5 +311,5 @@
"timezone": "",
"title": "Demo-Detailed Bug Info",
"uid": "s48Lzn5nz",
- "version": 1
+ "version": 2
}
\ No newline at end of file
diff --git a/grafana/dashboards/DemoHowFastDoWeRespondToCustomerRequirements.json b/grafana/dashboards/DemoHowFastDoWeRespondToCustomerRequirements.json
index 4a8c6b22..8517e28f 100644
--- a/grafana/dashboards/DemoHowFastDoWeRespondToCustomerRequirements.json
+++ b/grafana/dashboards/DemoHowFastDoWeRespondToCustomerRequirements.json
@@ -15,7 +15,7 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 64,
+ "id": 11,
"links": [
{
"asDropdown": false,
@@ -180,6 +180,28 @@
}
],
"type": "text"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 21
+ },
+ "id": 105,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"refresh": "",
@@ -197,5 +219,5 @@
"timezone": "",
"title": "Demo-How fast do we respond to customer requirements?",
"uid": "SupYz7c7z",
- "version": 11
-}
+ "version": 2
+}
\ No newline at end of file
diff --git a/grafana/dashboards/DemoIsThisMonthMoreProductiveThanLast.json b/grafana/dashboards/DemoIsThisMonthMoreProductiveThanLast.json
index 4cf33ccb..85cde9b0 100644
--- a/grafana/dashboards/DemoIsThisMonthMoreProductiveThanLast.json
+++ b/grafana/dashboards/DemoIsThisMonthMoreProductiveThanLast.json
@@ -15,7 +15,7 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 79,
+ "id": 5,
"links": [
{
"asDropdown": false,
@@ -210,6 +210,28 @@
}
],
"type": "text"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 21
+ },
+ "id": 42,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"refresh": "",
@@ -227,5 +249,5 @@
"timezone": "",
"title": "Demo-Is this month more productive than last?",
"uid": "ddREk75nk",
- "version": 6
-}
+ "version": 2
+}
\ No newline at end of file
diff --git a/grafana/dashboards/DemoWasOurQualityImprovedOrNot.json b/grafana/dashboards/DemoWasOurQualityImprovedOrNot.json
index 7aae3ad1..cef4b24a 100644
--- a/grafana/dashboards/DemoWasOurQualityImprovedOrNot.json
+++ b/grafana/dashboards/DemoWasOurQualityImprovedOrNot.json
@@ -15,7 +15,7 @@
"editable": true,
"gnetId": null,
"graphTooltip": 0,
- "id": 66,
+ "id": 6,
"links": [
{
"asDropdown": false,
@@ -177,6 +177,28 @@
}
],
"type": "text"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 20
+ },
+ "id": 39,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"refresh": "",
@@ -194,5 +216,5 @@
"timezone": "",
"title": "Demo-Was our quality improved or not?",
"uid": "G4DEk75nz",
- "version": 20
-}
+ "version": 2
+}
\ No newline at end of file
diff --git a/grafana/dashboards/EngineeringOverview.json b/grafana/dashboards/EngineeringOverview.json
index f56de168..cf01a059 100644
--- a/grafana/dashboards/EngineeringOverview.json
+++ b/grafana/dashboards/EngineeringOverview.json
@@ -16,7 +16,7 @@
"gnetId": null,
"graphTooltip": 0,
"id": 17,
- "iteration": 1658758283524,
+ "iteration": 1660821502959,
"links": [],
"panels": [
{
@@ -1716,6 +1716,28 @@
],
"title": "Work Done % [Selected Month]",
"type": "piechart"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 75
+ },
+ "id": 34,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"refresh": "",
@@ -1868,5 +1890,5 @@
"timezone": "",
"title": "Engineering Overview",
"uid": "ZF6abXX7z",
- "version": 8
+ "version": 9
}
\ No newline at end of file
diff --git a/grafana/dashboards/EngineeringThroughputAndCycleTime.json b/grafana/dashboards/EngineeringThroughputAndCycleTime.json
index cf838156..e8dc551e 100644
--- a/grafana/dashboards/EngineeringThroughputAndCycleTime.json
+++ b/grafana/dashboards/EngineeringThroughputAndCycleTime.json
@@ -16,14 +16,14 @@
"gnetId": null,
"graphTooltip": 0,
"id": 12,
- "iteration": 1658758247771,
+ "iteration": 1660821538920,
"links": [],
"panels": [
{
"datasource": null,
"gridPos": {
"h": 3,
- "w": 13,
+ "w": 24,
"x": 0,
"y": 0
},
@@ -761,6 +761,110 @@
"title": "PR Size",
"type": "timeseries"
},
+ {
+ "datasource": "mysql",
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "fixedColor": "blue",
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "axisLabel": "",
+ "axisPlacement": "auto",
+ "barAlignment": 0,
+ "drawStyle": "line",
+ "fillOpacity": 0,
+ "gradientMode": "none",
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ },
+ "lineInterpolation": "linear",
+ "lineWidth": 1,
+ "pointSize": 12,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "showPoints": "auto",
+ "spanNulls": false,
+ "stacking": {
+ "group": "A",
+ "mode": "none"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green",
+ "value": null
+ }
+ ]
+ }
+ },
+ "overrides": []
+ },
+ "gridPos": {
+ "h": 7,
+ "w": 8,
+ "x": 0,
+ "y": 18
+ },
+ "id": 108,
+ "options": {
+ "legend": {
+ "calcs": [
+ "mean"
+ ],
+ "displayMode": "list",
+ "placement": "bottom"
+ },
+ "tooltip": {
+ "mode": "single"
+ }
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "format": "table",
+ "group": [],
+ "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\nORDER BY 1",
+ "refId": "A",
+ "select": [
+ [
+ {
+ "params": [
+ "id"
+ ],
+ "type": "column"
+ }
+ ]
+ ],
+ "table": "ae_projects",
+ "timeColumn": "ae_create_time",
+ "timeColumnType": "timestamp",
+ "where": [
+ {
+ "name": "$__timeFilter",
+ "params": [],
+ "type": "macro"
+ }
+ ]
+ }
+ ],
+ "title": "PRs Merged w/o Review",
+ "type": "timeseries"
+ },
{
"collapsed": false,
"datasource": null,
@@ -768,11 +872,11 @@
"h": 1,
"w": 24,
"x": 0,
- "y": 18
+ "y": 25
},
"id": 103,
"panels": [],
- "title": "2. Quality + Cycle Time",
+ "title": "2. Cycle Time",
"type": "row"
},
{
@@ -860,7 +964,7 @@
"h": 7,
"w": 24,
"x": 0,
- "y": 19
+ "y": 26
},
"id": 109,
"options": {
@@ -964,7 +1068,7 @@
"h": 7,
"w": 8,
"x": 0,
- "y": 26
+ "y": 33
},
"id": 104,
"options": {
@@ -1099,7 +1203,7 @@
"h": 7,
"w": 8,
"x": 8,
- "y": 26
+ "y": 33
},
"id": 105,
"options": {
@@ -1234,7 +1338,7 @@
"h": 7,
"w": 8,
"x": 16,
- "y": 26
+ "y": 33
},
"id": 107,
"options": {
@@ -1285,108 +1389,26 @@
"type": "timeseries"
},
{
- "datasource": "mysql",
- "description": "",
- "fieldConfig": {
- "defaults": {
- "color": {
- "fixedColor": "blue",
- "mode": "palette-classic"
- },
- "custom": {
- "axisLabel": "",
- "axisPlacement": "auto",
- "barAlignment": 0,
- "drawStyle": "line",
- "fillOpacity": 0,
- "gradientMode": "none",
- "hideFrom": {
- "legend": false,
- "tooltip": false,
- "viz": false
- },
- "lineInterpolation": "linear",
- "lineWidth": 1,
- "pointSize": 12,
- "scaleDistribution": {
- "type": "linear"
- },
- "showPoints": "auto",
- "spanNulls": false,
- "stacking": {
- "group": "A",
- "mode": "none"
- },
- "thresholdsStyle": {
- "mode": "off"
- }
- },
- "mappings": [],
- "thresholds": {
- "mode": "absolute",
- "steps": [
- {
- "color": "green",
- "value": null
- }
- ]
- }
- },
- "overrides": []
- },
+ "datasource": null,
"gridPos": {
- "h": 7,
- "w": 8,
+ "h": 2,
+ "w": 24,
"x": 0,
- "y": 33
+ "y": 40
},
- "id": 108,
+ "id": 113,
"options": {
- "legend": {
- "calcs": [
- "mean"
- ],
- "displayMode": "list",
- "placement": "bottom"
- },
- "tooltip": {
- "mode": "single"
- }
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
},
"pluginVersion": "8.0.6",
"targets": [
{
- "format": "table",
- "group": [],
- "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\nORDER BY 1",
- "refId": "A",
- "select": [
- [
- {
- "params": [
- "id"
- ],
- "type": "column"
- }
- ]
- ],
- "table": "ae_projects",
- "timeColumn": "ae_create_time",
- "timeColumnType": "timestamp",
- "where": [
- {
- "name": "$__timeFilter",
- "params": [],
- "type": "macro"
- }
- ]
+ "queryType": "randomWalk",
+ "refId": "A"
}
],
- "title": "PRs Merged w/o Review",
- "type": "timeseries"
+ "type": "text"
}
],
"refresh": "",
@@ -1551,5 +1573,5 @@
"timezone": "",
"title": "Engineering Throughput and Cycle Time",
"uid": "Jaaimc67k",
- "version": 5
+ "version": 7
}
\ No newline at end of file
diff --git a/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json b/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
index 094760fb..b2e3b4f9 100644
--- a/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
+++ b/grafana/dashboards/EngineeringThroughputAndCycleTimeTeamView.json
@@ -16,14 +16,14 @@
"gnetId": null,
"graphTooltip": 0,
"id": 1,
- "iteration": 1658758034209,
+ "iteration": 1660821656496,
"links": [],
"panels": [
{
"datasource": null,
"gridPos": {
"h": 3,
- "w": 13,
+ "w": 24,
"x": 0,
"y": 0
},
@@ -2476,6 +2476,28 @@
],
"title": "7. PRs Merged w/o Review",
"type": "row"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 24
+ },
+ "id": 144,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"refresh": "",
@@ -2488,7 +2510,7 @@
"allValue": "",
"current": {
"isNone": true,
- "selected": false,
+ "selected": true,
"text": "None",
"value": ""
},
@@ -2690,5 +2712,5 @@
"timezone": "",
"title": "Engineering Throughput and Cycle Time - Team View",
"uid": "nJ1ijje7k",
- "version": 2
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/GitHub.json b/grafana/dashboards/GitHub.json
index b3087477..6267f4a6 100644
--- a/grafana/dashboards/GitHub.json
+++ b/grafana/dashboards/GitHub.json
@@ -16,7 +16,7 @@
"gnetId": null,
"graphTooltip": 0,
"id": 2,
- "iteration": 1658758592543,
+ "iteration": 1660821712964,
"links": [],
"panels": [
{
@@ -1931,6 +1931,28 @@
],
"title": "4.8 Mean Time to Close of Pull Requests in Days [Each Month]",
"type": "barchart"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 73
+ },
+ "id": 101,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"refresh": "",
@@ -1977,5 +1999,5 @@
"timezone": "",
"title": "GitHub",
"uid": "KXWvOFQnz",
- "version": 3
+ "version": 4
}
\ No newline at end of file
diff --git a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
index b4ca88b0..9edddbd0 100644
--- a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
+++ b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
@@ -16,7 +16,7 @@
"gnetId": null,
"graphTooltip": 0,
"id": 13,
- "iteration": 1658758698345,
+ "iteration": 1660822372857,
"links": [],
"panels": [
{
@@ -2578,6 +2578,28 @@
],
"title": "8.2 Top Contributors [Last 5 Tags]",
"type": "barchart"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 79
+ },
+ "id": 59,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"refresh": "",
@@ -2624,5 +2646,5 @@
"timezone": "",
"title": "GitHub_Release_Quality_and_Contribution_Analysis",
"uid": "2xuOaQUnk4",
- "version": 2
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/Gitlab.json b/grafana/dashboards/Gitlab.json
index 74b180c8..4ff3b9d2 100644
--- a/grafana/dashboards/Gitlab.json
+++ b/grafana/dashboards/Gitlab.json
@@ -16,7 +16,7 @@
"gnetId": null,
"graphTooltip": 0,
"id": 14,
- "iteration": 1658758604733,
+ "iteration": 1660820788891,
"links": [],
"panels": [
{
@@ -1079,14 +1079,14 @@
{
"datasource": null,
"gridPos": {
- "h": 3,
+ "h": 2,
"w": 24,
"x": 0,
"y": 41
},
"id": 99,
"options": {
- "content": "### Dashboard Guide\n\n1. The dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema).\n2. A [guide](https://devlake.apache.org/docs/UserManuals/GRAFANA) of how to create/edit a dashboard.",
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
"mode": "markdown"
},
"pluginVersion": "8.0.6",
@@ -1143,5 +1143,5 @@
"timezone": "",
"title": "GitLab",
"uid": "msSjEq97z",
- "version": 4
+ "version": 6
}
\ No newline at end of file
diff --git a/grafana/dashboards/Jenkins.json b/grafana/dashboards/Jenkins.json
index f2e13c1f..787dac40 100644
--- a/grafana/dashboards/Jenkins.json
+++ b/grafana/dashboards/Jenkins.json
@@ -16,7 +16,7 @@
"gnetId": null,
"graphTooltip": 0,
"id": 7,
- "iteration": 1658757686977,
+ "iteration": 1660821779393,
"links": [],
"panels": [
{
@@ -857,6 +857,28 @@
],
"title": "4.1 Mean Build Duration in Minutes [Each Month]",
"type": "barchart"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 27
+ },
+ "id": 60,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"schemaVersion": 30,
@@ -902,5 +924,5 @@
"timezone": "",
"title": "Jenkins",
"uid": "W8AiDFQnk",
- "version": 2
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/Jira.json b/grafana/dashboards/Jira.json
index 5fe5d0c1..44ddaf45 100644
--- a/grafana/dashboards/Jira.json
+++ b/grafana/dashboards/Jira.json
@@ -16,7 +16,7 @@
"gnetId": null,
"graphTooltip": 0,
"id": 8,
- "iteration": 1658757165613,
+ "iteration": 1660820809930,
"links": [
{
"asDropdown": false,
@@ -935,6 +935,28 @@
"align": false,
"alignLevel": null
}
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 29
+ },
+ "id": 130,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"refresh": "",
@@ -1005,5 +1027,5 @@
"timezone": "",
"title": "Jira",
"uid": "F5vqBQl7z",
- "version": 4
+ "version": 5
}
\ No newline at end of file
diff --git a/grafana/dashboards/WeeklyBugRetro.json b/grafana/dashboards/WeeklyBugRetro.json
index 6be6f14e..597a0581 100644
--- a/grafana/dashboards/WeeklyBugRetro.json
+++ b/grafana/dashboards/WeeklyBugRetro.json
@@ -16,14 +16,14 @@
"gnetId": null,
"graphTooltip": 0,
"id": 15,
- "iteration": 1658757077334,
+ "iteration": 1660821861545,
"links": [],
"panels": [
{
"datasource": null,
"gridPos": {
"h": 3,
- "w": 13,
+ "w": 24,
"x": 0,
"y": 0
},
@@ -1472,6 +1472,28 @@
],
"title": "Total Outstanding Bug Count by Week [Selected Time Range]",
"type": "barchart"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 74
+ },
+ "id": 30,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"schemaVersion": 30,
@@ -1537,5 +1559,5 @@
"timezone": "",
"title": "Weekly Bug Retro",
"uid": "-5EKA5w7k",
- "version": 2
+ "version": 3
}
\ No newline at end of file
diff --git a/grafana/dashboards/WeeklyCommunityRetro.json b/grafana/dashboards/WeeklyCommunityRetro.json
index 6765507b..9479bc8e 100644
--- a/grafana/dashboards/WeeklyCommunityRetro.json
+++ b/grafana/dashboards/WeeklyCommunityRetro.json
@@ -16,14 +16,14 @@
"gnetId": null,
"graphTooltip": 0,
"id": 9,
- "iteration": 1658758447987,
+ "iteration": 1660821905109,
"links": [],
"panels": [
{
"datasource": null,
"gridPos": {
"h": 3,
- "w": 13,
+ "w": 23,
"x": 0,
"y": 0
},
@@ -1670,6 +1670,28 @@
],
"title": "Top Community Contributors By PRs Created [All History]",
"type": "bargauge"
+ },
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 2,
+ "w": 24,
+ "x": 0,
+ "y": 54
+ },
+ "id": 50,
+ "options": {
+ "content": "<br/>\n\nThis dashboard is created based on this [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema). Want to add more metrics? Please follow the [guide](https://devlake.apache.org/docs/UserManuals/Dashboards/GrafanaUserGuide).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "type": "text"
}
],
"refresh": "",
@@ -1768,5 +1790,5 @@
"timezone": "",
"title": "Weekly Community Retro",
"uid": "VTr6Y_q7z",
- "version": 5
+ "version": 7
}
\ No newline at end of file