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 78f8394e0 fix: update dashboards stylings and SQLs (#5645)
78f8394e0 is described below
commit 78f8394e0c9ec0a62a9acceb97452fc48cec441d
Author: Louis.z <[email protected]>
AuthorDate: Fri Jul 7 10:47:02 2023 +0800
fix: update dashboards stylings and SQLs (#5645)
* fix: update dashboard stylings
* fix: update the definition of contributors
---------
Co-authored-by: Startrekzky <[email protected]>
---
grafana/dashboards/GitHub.json | 523 +++++++++++---
grafana/dashboards/WeeklyBugRetro.json | 422 +++++++++---
grafana/dashboards/WeeklyCommunityRetro.json | 981 ++++++++++++++++++++-------
3 files changed, 1528 insertions(+), 398 deletions(-)
diff --git a/grafana/dashboards/GitHub.json b/grafana/dashboards/GitHub.json
index 5dd0ce34a..b77568185 100644
--- a/grafana/dashboards/GitHub.json
+++ b/grafana/dashboards/GitHub.json
@@ -3,7 +3,10 @@
"list": [
{
"builtIn": 1,
- "datasource": "-- Grafana --",
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
@@ -13,14 +16,17 @@
]
},
"editable": true,
- "gnetId": null,
+ "fiscalYearStartMonth": 0,
"graphTooltip": 0,
- "id": 26,
- "iteration": 1683710488565,
+ "id": 18,
"links": [],
+ "liveNow": false,
"panels": [
{
- "datasource": null,
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"gridPos": {
"h": 3,
"w": 13,
@@ -29,12 +35,21 @@
},
"id": 99,
"options": {
+ "code": {
+ "language": "plaintext",
+ "showLineNumbers": false,
+ "showMiniMap": false
+ },
"content": "- Use Cases: This dashboard shows the basic Git and Code
Review metrics from GitHub.\n- Data Source Required: GitHub",
"mode": "markdown"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"queryType": "randomWalk",
"refId": "A"
}
@@ -44,7 +59,10 @@
},
{
"collapsed": false,
- "datasource": null,
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"gridPos": {
"h": 1,
"w": 24,
@@ -53,11 +71,23 @@
},
"id": 89,
"panels": [],
+ "targets": [
+ {
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
+ "refId": "A"
+ }
+ ],
"title": "1. User Requirements (Issues)",
"type": "row"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -103,9 +133,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -139,7 +173,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -147,6 +184,8 @@
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "Issue Count",
"axisPlacement": "auto",
"axisSoftMin": 0,
@@ -157,7 +196,13 @@
"tooltip": false,
"viz": false
},
- "lineWidth": 1
+ "lineWidth": 1,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
},
"mappings": [],
"thresholds": {
@@ -184,27 +229,38 @@
},
"id": 74,
"options": {
+ "barRadius": 0,
"barWidth": 0.5,
+ "fullHighlight": false,
"groupWidth": 0.7,
"legend": {
"calcs": [
"mean"
],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"orientation": "auto",
"showValue": "auto",
+ "stacking": "none",
"text": {
"valueSize": 12
},
"tooltip": {
- "mode": "single"
- }
+ "mode": "single",
+ "sort": "none"
+ },
+ "xTickLabelRotation": 0,
+ "xTickLabelSpacing": 0
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -239,7 +295,10 @@
},
{
"collapsed": false,
- "datasource": null,
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"gridPos": {
"h": 1,
"w": 24,
@@ -248,11 +307,23 @@
},
"id": 87,
"panels": [],
+ "targets": [
+ {
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
+ "refId": "A"
+ }
+ ],
"title": "2. How issues are handled?",
"type": "row"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -298,9 +369,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -334,7 +409,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -342,6 +420,8 @@
"mode": "fixed"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "Issue Count",
"axisPlacement": "auto",
"barAlignment": 1,
@@ -415,15 +495,21 @@
"sum"
],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"tooltip": {
- "mode": "multi"
+ "mode": "multi",
+ "sort": "none"
}
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "time_series",
"group": [],
"hide": false,
@@ -457,7 +543,10 @@
"type": "timeseries"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -503,9 +592,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -539,7 +632,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -547,6 +643,8 @@
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
@@ -557,7 +655,13 @@
"tooltip": false,
"viz": false
},
- "lineWidth": 1
+ "lineWidth": 1,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
},
"mappings": [],
"thresholds": {
@@ -584,25 +688,36 @@
},
"id": 75,
"options": {
+ "barRadius": 0,
"barWidth": 0.5,
+ "fullHighlight": false,
"groupWidth": 0.7,
"legend": {
"calcs": [],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"orientation": "auto",
"showValue": "auto",
+ "stacking": "none",
"text": {
"valueSize": 12
},
"tooltip": {
- "mode": "single"
- }
+ "mode": "single",
+ "sort": "none"
+ },
+ "xTickLabelRotation": 0,
+ "xTickLabelSpacing": 0
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -636,7 +751,10 @@
"type": "barchart"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -644,17 +762,25 @@
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "Queue Time (Days)",
"axisPlacement": "auto",
"axisSoftMin": 0,
- "fillOpacity": 80,
+ "fillOpacity": 100,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
- "lineWidth": 1
+ "lineWidth": 1,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "thresholdsStyle": {
+ "mode": "line"
+ }
},
"mappings": [],
"thresholds": {
@@ -666,7 +792,7 @@
},
{
"color": "red",
- "value": 80
+ "value": 30
}
]
},
@@ -682,31 +808,43 @@
},
"id": 93,
"options": {
+ "barRadius": 0,
"barWidth": 0.1,
+ "fullHighlight": false,
"groupWidth": 0.7,
"legend": {
"calcs": [
"mean"
],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"orientation": "auto",
"showValue": "auto",
+ "stacking": "none",
"text": {},
"tooltip": {
- "mode": "single"
- }
+ "mode": "multi",
+ "sort": "none"
+ },
+ "xTickLabelRotation": 45,
+ "xTickLabelSpacing": 0
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
+ "editorMode": "code",
"format": "table",
"group": [],
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the queue time of all outstanding bugs\nwith
_outstanding_issues as(\n select \n b.name as repo_name,\n i.issue_key
as issue_key,\n i.title,\n i.created_date,\n (TIMESTAMPDIFF(MINUTE,
i.created_date,NOW()))/1440 as queue_time_in_days,\n
concat(b.url,'/',i.issue_key) as url\n from \n issues i\n left join
board_issues bi on i.id = bi.issue_id\n left join boards b on bi.board_id =
b.id\n where\n b.id in ($repo_id)\n and $__time [...]
+ "rawSql": "-- Get the queue time of all outstanding bugs\nwith
_outstanding_issues as(\n select \n DISTINCT\n b.name as repo_name,\n
i.issue_key as issue_key,\n i.title,\n i.created_date,\n
(TIMESTAMPDIFF(MINUTE, i.created_date,NOW()))/1440 as queue_time_in_days,\n
concat(b.url,'/',i.issue_key) as url\n from \n issues i\n left join
board_issues bi on i.id = bi.issue_id\n left join boards b on bi.board_id =
b.id\n where\n b.id in ($repo_id)\n [...]
"refId": "A",
"select": [
[
@@ -718,6 +856,23 @@
}
]
],
+ "sql": {
+ "columns": [
+ {
+ "parameters": [],
+ "type": "function"
+ }
+ ],
+ "groupBy": [
+ {
+ "property": {
+ "type": "string"
+ },
+ "type": "groupBy"
+ }
+ ],
+ "limit": 50
+ },
"table": "ae_projects",
"timeColumn": "ae_create_time",
"timeColumnType": "timestamp",
@@ -734,7 +889,10 @@
"type": "barchart"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -743,7 +901,10 @@
},
"custom": {
"align": "auto",
- "displayMode": "auto"
+ "cellOptions": {
+ "type": "auto"
+ },
+ "inspect": false
},
"mappings": [],
"thresholds": {
@@ -862,12 +1023,25 @@
},
"id": 92,
"options": {
+ "cellHeight": "sm",
+ "footer": {
+ "countRows": false,
+ "fields": "",
+ "reducer": [
+ "sum"
+ ],
+ "show": false
+ },
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -902,7 +1076,10 @@
},
{
"collapsed": false,
- "datasource": null,
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"gridPos": {
"h": 1,
"w": 24,
@@ -911,11 +1088,23 @@
},
"id": 83,
"panels": [],
+ "targets": [
+ {
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
+ "refId": "A"
+ }
+ ],
"title": "3. Contribution (PRs)",
"type": "row"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -961,9 +1150,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -997,7 +1190,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1005,6 +1201,8 @@
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
@@ -1015,7 +1213,13 @@
"tooltip": false,
"viz": false
},
- "lineWidth": 1
+ "lineWidth": 1,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
},
"mappings": [],
"thresholds": {
@@ -1042,25 +1246,36 @@
},
"id": 77,
"options": {
+ "barRadius": 0,
"barWidth": 0.5,
+ "fullHighlight": false,
"groupWidth": 0.7,
"legend": {
"calcs": [],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"orientation": "auto",
"showValue": "auto",
+ "stacking": "none",
"text": {
"valueSize": 12
},
"tooltip": {
- "mode": "single"
- }
+ "mode": "single",
+ "sort": "none"
+ },
+ "xTickLabelRotation": 0,
+ "xTickLabelSpacing": 0
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -1094,7 +1309,10 @@
"type": "barchart"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1102,6 +1320,8 @@
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "Merged PR Count",
"axisPlacement": "auto",
"axisSoftMin": 0,
@@ -1112,7 +1332,13 @@
"tooltip": false,
"viz": false
},
- "lineWidth": 1
+ "lineWidth": 1,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
},
"mappings": [],
"thresholds": {
@@ -1140,25 +1366,36 @@
},
"id": 59,
"options": {
+ "barRadius": 0,
"barWidth": 0.5,
+ "fullHighlight": false,
"groupWidth": 0.7,
"legend": {
"calcs": [],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"orientation": "auto",
"showValue": "auto",
+ "stacking": "none",
"text": {
"valueSize": 12
},
"tooltip": {
- "mode": "multi"
- }
+ "mode": "multi",
+ "sort": "none"
+ },
+ "xTickLabelRotation": 0,
+ "xTickLabelSpacing": 0
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -1193,7 +1430,10 @@
},
{
"collapsed": false,
- "datasource": null,
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"gridPos": {
"h": 1,
"w": 24,
@@ -1202,11 +1442,23 @@
},
"id": 85,
"panels": [],
+ "targets": [
+ {
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
+ "refId": "A"
+ }
+ ],
"title": "4. How PRs are handled?",
"type": "row"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1251,9 +1503,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -1287,7 +1543,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1295,6 +1554,8 @@
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "Pull Request Count",
"axisPlacement": "auto",
"barAlignment": 1,
@@ -1348,15 +1609,21 @@
"sum"
],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"tooltip": {
- "mode": "multi"
+ "mode": "multi",
+ "sort": "none"
}
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "time_series",
"group": [],
"hide": false,
@@ -1390,7 +1657,10 @@
"type": "timeseries"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1436,9 +1706,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -1472,7 +1746,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1480,6 +1757,8 @@
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "Ratio",
"axisPlacement": "auto",
"barAlignment": 1,
@@ -1535,15 +1814,21 @@
"legend": {
"calcs": [],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"tooltip": {
- "mode": "multi"
+ "mode": "multi",
+ "sort": "none"
}
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "time_series",
"group": [],
"hide": false,
@@ -1577,7 +1862,10 @@
"type": "timeseries"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1623,9 +1911,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -1659,7 +1951,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1667,6 +1962,8 @@
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
@@ -1677,7 +1974,13 @@
"tooltip": false,
"viz": false
},
- "lineWidth": 1
+ "lineWidth": 1,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
},
"mappings": [],
"thresholds": {
@@ -1704,25 +2007,36 @@
},
"id": 95,
"options": {
+ "barRadius": 0,
"barWidth": 0.5,
+ "fullHighlight": false,
"groupWidth": 0.7,
"legend": {
"calcs": [],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"orientation": "auto",
"showValue": "auto",
+ "stacking": "none",
"text": {
"valueSize": 12
},
"tooltip": {
- "mode": "single"
- }
+ "mode": "single",
+ "sort": "none"
+ },
+ "xTickLabelRotation": 0,
+ "xTickLabelSpacing": 0
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -1756,7 +2070,10 @@
"type": "barchart"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1800,9 +2117,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -1836,7 +2157,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1844,6 +2168,8 @@
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
@@ -1854,7 +2180,13 @@
"tooltip": false,
"viz": false
},
- "lineWidth": 1
+ "lineWidth": 1,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
},
"mappings": [],
"thresholds": {
@@ -1881,25 +2213,36 @@
},
"id": 97,
"options": {
+ "barRadius": 0,
"barWidth": 0.5,
+ "fullHighlight": false,
"groupWidth": 0.7,
"legend": {
"calcs": [],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"orientation": "auto",
"showValue": "auto",
+ "stacking": "none",
"text": {
"valueSize": 12
},
"tooltip": {
- "mode": "single"
- }
+ "mode": "single",
+ "sort": "none"
+ },
+ "xTickLabelRotation": 0,
+ "xTickLabelSpacing": 0
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -1933,7 +2276,10 @@
"type": "barchart"
},
{
- "datasource": null,
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"gridPos": {
"h": 2,
"w": 24,
@@ -1942,12 +2288,21 @@
},
"id": 101,
"options": {
+ "code": {
+ "language": "plaintext",
+ "showLineNumbers": false,
+ "showMiniMap": false
+ },
"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/Configuration/Dashboards/GrafanaUserGuide).",
"mode": "markdown"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"queryType": "randomWalk",
"refId": "A"
}
@@ -1956,7 +2311,7 @@
}
],
"refresh": "",
- "schemaVersion": 30,
+ "schemaVersion": 38,
"style": "dark",
"tags": [],
"templating": {
@@ -1972,10 +2327,11 @@
"$__all"
]
},
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"definition": "select concat(name, '--', id) as text from repos where
id like 'github%'",
- "description": null,
- "error": null,
"hide": 0,
"includeAll": true,
"label": "Repo",
@@ -1999,5 +2355,6 @@
"timezone": "",
"title": "GitHub",
"uid": "KXWvOFQnz",
- "version": 10
+ "version": 2,
+ "weekStart": ""
}
\ No newline at end of file
diff --git a/grafana/dashboards/WeeklyBugRetro.json
b/grafana/dashboards/WeeklyBugRetro.json
index 7e33ce822..abee64503 100644
--- a/grafana/dashboards/WeeklyBugRetro.json
+++ b/grafana/dashboards/WeeklyBugRetro.json
@@ -3,7 +3,10 @@
"list": [
{
"builtIn": 1,
- "datasource": "-- Grafana --",
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
@@ -13,14 +16,17 @@
]
},
"editable": true,
- "gnetId": null,
+ "fiscalYearStartMonth": 0,
"graphTooltip": 0,
- "id": 13,
- "iteration": 1681785827220,
+ "id": 3,
"links": [],
+ "liveNow": false,
"panels": [
{
- "datasource": null,
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"gridPos": {
"h": 3,
"w": 24,
@@ -29,12 +35,21 @@
},
"id": 28,
"options": {
+ "code": {
+ "language": "plaintext",
+ "showLineNumbers": false,
+ "showMiniMap": false
+ },
"content": "- Use Cases: This dashboard can be used to track bugs with
metrics such as [Bug Age](https://devlake.apache.org/docs/Metrics/BugAge).\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 configu [...]
"mode": "markdown"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"queryType": "randomWalk",
"refId": "A"
}
@@ -43,7 +58,10 @@
"type": "text"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -88,9 +106,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -124,7 +146,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -156,6 +181,7 @@
"legend": {
"displayMode": "list",
"placement": "bottom",
+ "showLegend": true,
"values": [
"percent",
"value"
@@ -168,12 +194,17 @@
"values": true
},
"tooltip": {
- "mode": "multi"
+ "mode": "multi",
+ "sort": "none"
}
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -207,7 +238,10 @@
"type": "piechart"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -215,7 +249,10 @@
},
"custom": {
"align": "auto",
- "displayMode": "auto"
+ "cellOptions": {
+ "type": "auto"
+ },
+ "inspect": false
},
"mappings": [],
"thresholds": {
@@ -320,12 +357,25 @@
},
"id": 4,
"options": {
+ "cellHeight": "sm",
+ "footer": {
+ "countRows": false,
+ "fields": "",
+ "reducer": [
+ "sum"
+ ],
+ "show": false
+ },
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -359,7 +409,10 @@
"type": "table"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -404,9 +457,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -440,7 +497,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -490,9 +550,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -526,7 +590,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -534,7 +601,10 @@
},
"custom": {
"align": "auto",
- "displayMode": "auto"
+ "cellOptions": {
+ "type": "auto"
+ },
+ "inspect": false
},
"mappings": [],
"thresholds": {
@@ -595,8 +665,10 @@
},
"properties": [
{
- "id": "custom.displayMode",
- "value": "color-text"
+ "id": "custom.cellOptions",
+ "value": {
+ "type": "color-text"
+ }
}
]
}
@@ -610,12 +682,25 @@
},
"id": 10,
"options": {
+ "cellHeight": "sm",
+ "footer": {
+ "countRows": false,
+ "fields": "",
+ "reducer": [
+ "sum"
+ ],
+ "show": false
+ },
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -649,13 +734,18 @@
"type": "table"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
@@ -666,7 +756,13 @@
"tooltip": false,
"viz": false
},
- "lineWidth": 1
+ "lineWidth": 1,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
},
"decimals": 1,
"mappings": [],
@@ -694,25 +790,36 @@
},
"id": 23,
"options": {
+ "barRadius": 0,
"barWidth": 0.3,
+ "fullHighlight": false,
"groupWidth": 0.7,
"legend": {
"calcs": [
"mean"
],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"orientation": "horizontal",
"showValue": "auto",
+ "stacking": "none",
"text": {},
"tooltip": {
- "mode": "single"
- }
+ "mode": "single",
+ "sort": "none"
+ },
+ "xTickLabelRotation": 0,
+ "xTickLabelSpacing": 0
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -746,7 +853,10 @@
"type": "barchart"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -791,9 +901,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -827,7 +941,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -872,9 +989,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -908,7 +1029,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -916,7 +1040,10 @@
},
"custom": {
"align": "auto",
- "displayMode": "auto"
+ "cellOptions": {
+ "type": "auto"
+ },
+ "inspect": false
},
"mappings": [],
"thresholds": {
@@ -989,8 +1116,10 @@
},
"properties": [
{
- "id": "custom.displayMode",
- "value": "color-text"
+ "id": "custom.cellOptions",
+ "value": {
+ "type": "color-text"
+ }
}
]
},
@@ -1001,8 +1130,7 @@
},
"properties": [
{
- "id": "custom.width",
- "value": null
+ "id": "custom.width"
}
]
}
@@ -1016,12 +1144,25 @@
},
"id": 14,
"options": {
+ "cellHeight": "sm",
+ "footer": {
+ "countRows": false,
+ "fields": "",
+ "reducer": [
+ "sum"
+ ],
+ "show": false
+ },
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -1055,13 +1196,18 @@
"type": "table"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "Queue Time in Days",
"axisPlacement": "auto",
"axisSoftMin": 0,
@@ -1072,7 +1218,13 @@
"tooltip": false,
"viz": false
},
- "lineWidth": 1
+ "lineWidth": 1,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
},
"mappings": [],
"thresholds": {
@@ -1099,7 +1251,9 @@
},
"id": 18,
"options": {
+ "barRadius": 0,
"barWidth": 0.3,
+ "fullHighlight": false,
"groupWidth": 0.7,
"legend": {
"calcs": [
@@ -1107,20 +1261,29 @@
"max"
],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"orientation": "auto",
"showValue": "always",
+ "stacking": "none",
"text": {
"valueSize": 12
},
"tooltip": {
- "mode": "single"
- }
+ "mode": "single",
+ "sort": "none"
+ },
+ "xTickLabelRotation": 45,
+ "xTickLabelSpacing": 0
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -1154,7 +1317,10 @@
"type": "barchart"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -1162,7 +1328,10 @@
},
"custom": {
"align": "auto",
- "displayMode": "auto"
+ "cellOptions": {
+ "type": "auto"
+ },
+ "inspect": false
},
"mappings": [],
"thresholds": {
@@ -1223,8 +1392,10 @@
},
"properties": [
{
- "id": "custom.displayMode",
- "value": "color-text"
+ "id": "custom.cellOptions",
+ "value": {
+ "type": "color-text"
+ }
}
]
}
@@ -1238,12 +1409,25 @@
},
"id": 31,
"options": {
+ "cellHeight": "sm",
+ "footer": {
+ "countRows": false,
+ "fields": "",
+ "reducer": [
+ "sum"
+ ],
+ "show": false
+ },
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -1277,13 +1461,18 @@
"type": "table"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
@@ -1294,7 +1483,13 @@
"tooltip": false,
"viz": false
},
- "lineWidth": 1
+ "lineWidth": 1,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
},
"mappings": [],
"thresholds": {
@@ -1321,24 +1516,35 @@
},
"id": 2,
"options": {
+ "barRadius": 0,
"barWidth": 0.71,
+ "fullHighlight": false,
"groupWidth": 0.7,
"legend": {
"calcs": [],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"orientation": "auto",
"showValue": "auto",
+ "stacking": "none",
"text": {
"valueSize": 12
},
"tooltip": {
- "mode": "single"
- }
+ "mode": "single",
+ "sort": "none"
+ },
+ "xTickLabelRotation": 45,
+ "xTickLabelSpacing": 0
},
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -1372,13 +1578,18 @@
"type": "barchart"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
@@ -1389,7 +1600,13 @@
"tooltip": false,
"viz": false
},
- "lineWidth": 1
+ "lineWidth": 1,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
},
"mappings": [],
"thresholds": {
@@ -1416,24 +1633,35 @@
},
"id": 20,
"options": {
+ "barRadius": 0,
"barWidth": 0.71,
+ "fullHighlight": false,
"groupWidth": 0.7,
"legend": {
"calcs": [],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"orientation": "auto",
"showValue": "auto",
+ "stacking": "none",
"text": {
"valueSize": 12
},
"tooltip": {
- "mode": "single"
- }
+ "mode": "single",
+ "sort": "none"
+ },
+ "xTickLabelRotation": 45,
+ "xTickLabelSpacing": 0
},
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -1467,13 +1695,18 @@
"type": "barchart"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
@@ -1484,7 +1717,13 @@
"tooltip": false,
"viz": false
},
- "lineWidth": 1
+ "lineWidth": 1,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
},
"mappings": [],
"thresholds": {
@@ -1511,26 +1750,37 @@
},
"id": 21,
"options": {
+ "barRadius": 0,
"barWidth": 0.71,
+ "fullHighlight": false,
"groupWidth": 0.7,
"legend": {
"calcs": [
"mean"
],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"orientation": "auto",
"showValue": "auto",
+ "stacking": "none",
"text": {
"valueSize": 12
},
"tooltip": {
- "mode": "single"
- }
+ "mode": "single",
+ "sort": "none"
+ },
+ "xTickLabelRotation": 45,
+ "xTickLabelSpacing": 0
},
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -1564,7 +1814,10 @@
"type": "barchart"
},
{
- "datasource": null,
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"gridPos": {
"h": 2,
"w": 24,
@@ -1573,12 +1826,21 @@
},
"id": 30,
"options": {
+ "code": {
+ "language": "plaintext",
+ "showLineNumbers": false,
+ "showMiniMap": false
+ },
"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",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"queryType": "randomWalk",
"refId": "A"
}
@@ -1586,22 +1848,23 @@
"type": "text"
}
],
- "schemaVersion": 30,
+ "refresh": "",
+ "schemaVersion": 38,
"style": "dark",
"tags": [],
"templating": {
"list": [
{
- "allValue": null,
"current": {
"selected": false,
"text": "All",
"value": "$__all"
},
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"definition": "select concat(name, '-', id) as text from boards",
- "description": null,
- "error": null,
"hide": 0,
"includeAll": true,
"label": "Board",
@@ -1616,16 +1879,16 @@
"type": "query"
},
{
- "allValue": null,
"current": {
"selected": false,
"text": "BUG",
"value": "BUG"
},
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"definition": "select distinct type from issues",
- "description": null,
- "error": null,
"hide": 0,
"includeAll": true,
"label": "Issue Type",
@@ -1640,7 +1903,6 @@
"type": "query"
},
{
- "allValue": null,
"current": {
"selected": true,
"text": [
@@ -1650,10 +1912,11 @@
"$__all"
]
},
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"definition": "select distinct priority from issues",
- "description": null,
- "error": null,
"hide": 0,
"includeAll": true,
"label": "Priority",
@@ -1677,5 +1940,6 @@
"timezone": "",
"title": "Weekly Bug Retro",
"uid": "-5EKA5w7k",
- "version": 23
+ "version": 2,
+ "weekStart": ""
}
\ No newline at end of file
diff --git a/grafana/dashboards/WeeklyCommunityRetro.json
b/grafana/dashboards/WeeklyCommunityRetro.json
index d219c91f3..539fbaee1 100644
--- a/grafana/dashboards/WeeklyCommunityRetro.json
+++ b/grafana/dashboards/WeeklyCommunityRetro.json
@@ -3,7 +3,10 @@
"list": [
{
"builtIn": 1,
- "datasource": "-- Grafana --",
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
@@ -13,28 +16,40 @@
]
},
"editable": true,
- "gnetId": null,
+ "fiscalYearStartMonth": 0,
"graphTooltip": 0,
- "id": 27,
- "iteration": 1682063086384,
+ "id": 28,
"links": [],
+ "liveNow": false,
"panels": [
{
- "datasource": null,
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"gridPos": {
- "h": 3,
- "w": 23,
+ "h": 4,
+ "w": 24,
"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.",
+ "code": {
+ "language": "plaintext",
+ "showLineNumbers": false,
+ "showMiniMap": false
+ },
+ "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.\n- This dashboa [...]
"mode": "markdown"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"queryType": "randomWalk",
"refId": "A"
}
@@ -44,20 +59,35 @@
},
{
"collapsed": false,
- "datasource": null,
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
- "y": 3
+ "y": 4
},
"id": 42,
"panels": [],
+ "targets": [
+ {
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
+ "refId": "A"
+ }
+ ],
"title": "Community Issues",
"type": "row"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -84,7 +114,7 @@
"h": 8,
"w": 8,
"x": 0,
- "y": 4
+ "y": 5
},
"id": 6,
"options": {
@@ -102,9 +132,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -138,7 +172,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -165,7 +202,7 @@
"h": 8,
"w": 6,
"x": 8,
- "y": 4
+ "y": 5
},
"id": 22,
"options": {
@@ -183,9 +220,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -219,7 +260,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -247,7 +291,7 @@
"h": 8,
"w": 6,
"x": 14,
- "y": 4
+ "y": 5
},
"id": 23,
"options": {
@@ -265,9 +309,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -301,7 +349,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -309,7 +360,10 @@
},
"custom": {
"align": "auto",
- "displayMode": "auto"
+ "cellOptions": {
+ "type": "auto"
+ },
+ "inspect": false
},
"mappings": [],
"thresholds": {
@@ -332,15 +386,28 @@
"h": 8,
"w": 4,
"x": 20,
- "y": 4
+ "y": 5
},
"id": 45,
"options": {
+ "cellHeight": "sm",
+ "footer": {
+ "countRows": false,
+ "fields": "",
+ "reducer": [
+ "sum"
+ ],
+ "show": false
+ },
"showHeader": true
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -374,7 +441,10 @@
"type": "table"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -406,7 +476,7 @@
"h": 8,
"w": 8,
"x": 0,
- "y": 12
+ "y": 13
},
"id": 24,
"options": {
@@ -424,9 +494,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -460,7 +534,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -468,7 +545,10 @@
},
"custom": {
"align": "auto",
- "displayMode": "auto"
+ "cellOptions": {
+ "type": "auto"
+ },
+ "inspect": false
},
"mappings": [],
"thresholds": {
@@ -480,7 +560,7 @@
},
{
"color": "red",
- "value": 80
+ "value": 3
}
]
}
@@ -537,12 +617,26 @@
{
"matcher": {
"id": "byName",
- "options": "issue_number"
+ "options": "queue_time_in_days"
+ },
+ "properties": [
+ {
+ "id": "custom.cellOptions",
+ "value": {
+ "type": "color-text"
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "issue_key"
},
"properties": [
{
"id": "custom.width",
- "value": 125
+ "value": 95
}
]
}
@@ -552,22 +646,36 @@
"h": 8,
"w": 16,
"x": 8,
- "y": 12
+ "y": 13
},
"id": 25,
"options": {
+ "cellHeight": "sm",
+ "footer": {
+ "countRows": false,
+ "fields": "",
+ "reducer": [
+ "sum"
+ ],
+ "show": false
+ },
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
+ "editorMode": "code",
"format": "table",
"group": [],
"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.creator_name,\n i.created_date as
issue_created_date,\n i.status,\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.boa [...]
+ "rawSql": "with issue_comment_list as(\n select\n i.id as
issue_id,\n i.url,\n i.issue_key,\n i.title,\n i.creator_name,\n
i.created_date as issue_created_date,\n i.status,\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 [...]
"refId": "A",
"select": [
[
@@ -579,6 +687,23 @@
}
]
],
+ "sql": {
+ "columns": [
+ {
+ "parameters": [],
+ "type": "function"
+ }
+ ],
+ "groupBy": [
+ {
+ "property": {
+ "type": "string"
+ },
+ "type": "groupBy"
+ }
+ ],
+ "limit": 50
+ },
"table": "_devlake_migration_history",
"timeColumn": "created_at",
"timeColumnType": "timestamp",
@@ -595,7 +720,10 @@
"type": "table"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -627,7 +755,7 @@
"h": 8,
"w": 8,
"x": 0,
- "y": 20
+ "y": 21
},
"id": 26,
"options": {
@@ -645,9 +773,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -681,7 +813,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -689,7 +824,10 @@
},
"custom": {
"align": "auto",
- "displayMode": "auto"
+ "cellOptions": {
+ "type": "auto"
+ },
+ "inspect": false
},
"mappings": [],
"thresholds": {
@@ -699,13 +837,9 @@
"color": "green",
"value": null
},
- {
- "color": "#EAB839",
- "value": 0.2
- },
{
"color": "red",
- "value": 0.5
+ "value": 3
}
]
},
@@ -715,60 +849,60 @@
{
"matcher": {
"id": "byName",
- "options": "body"
+ "options": "title"
},
"properties": [
{
"id": "custom.width",
- "value": 364
+ "value": 451
}
]
},
{
"matcher": {
"id": "byName",
- "options": "url"
+ "options": "creator_name"
},
"properties": [
{
"id": "custom.width",
- "value": null
+ "value": 146
}
]
},
{
"matcher": {
"id": "byName",
- "options": "issue_id"
+ "options": "issue_created_date"
},
"properties": [
{
"id": "custom.width",
- "value": 73
+ "value": 162
}
]
},
{
"matcher": {
"id": "byName",
- "options": "comment_id"
+ "options": "comment_date"
},
"properties": [
{
"id": "custom.width",
- "value": 106
+ "value": 160
}
]
},
{
"matcher": {
"id": "byName",
- "options": "comment_rank"
+ "options": "issue_key"
},
"properties": [
{
"id": "custom.width",
- "value": 28
+ "value": 96
}
]
},
@@ -780,79 +914,13 @@
"properties": [
{
"id": "custom.width",
- "value": 184
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "issue_nunber"
- },
- "properties": [
- {
- "id": "custom.width",
- "value": 127
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "issue_number"
- },
- "properties": [
- {
- "id": "custom.width",
- "value": 122
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "title"
- },
- "properties": [
- {
- "id": "custom.width",
- "value": 451
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "creator_name"
- },
- "properties": [
- {
- "id": "custom.width",
- "value": 146
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "issue_created_date"
- },
- "properties": [
- {
- "id": "custom.width",
- "value": 162
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "comment_date"
- },
- "properties": [
+ "value": 211
+ },
{
- "id": "custom.width",
- "value": 160
+ "id": "custom.cellOptions",
+ "value": {
+ "type": "color-text"
+ }
}
]
}
@@ -862,22 +930,36 @@
"h": 8,
"w": 16,
"x": 8,
- "y": 20
+ "y": 21
},
"id": 28,
"options": {
+ "cellHeight": "sm",
+ "footer": {
+ "countRows": false,
+ "fields": "",
+ "reducer": [
+ "sum"
+ ],
+ "show": false
+ },
"showHeader": true,
"sortBy": []
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
+ "editorMode": "code",
"format": "table",
"group": [],
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "with issue_comment_list as(\n select\n
SUBSTRING_INDEX(i.url, '/', -1) as issue_number,\n i.url,\n i.title,\n
i.creator_name,\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 bo [...]
+ "rawSql": "with issue_comment_list as(\n select\n
SUBSTRING_INDEX(i.url, '/', -1) as issue_number,\n i.url,\n
i.issue_key,\n i.title,\n i.creator_name,\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.iss
[...]
"refId": "A",
"select": [
[
@@ -889,6 +971,23 @@
}
]
],
+ "sql": {
+ "columns": [
+ {
+ "parameters": [],
+ "type": "function"
+ }
+ ],
+ "groupBy": [
+ {
+ "property": {
+ "type": "string"
+ },
+ "type": "groupBy"
+ }
+ ],
+ "limit": 50
+ },
"table": "_devlake_migration_history",
"timeColumn": "created_at",
"timeColumnType": "timestamp",
@@ -906,20 +1005,35 @@
},
{
"collapsed": false,
- "datasource": null,
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
- "y": 28
+ "y": 29
},
"id": 44,
"panels": [],
+ "targets": [
+ {
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
+ "refId": "A"
+ }
+ ],
"title": "Community PRs",
"type": "row"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -947,7 +1061,7 @@
"h": 8,
"w": 8,
"x": 0,
- "y": 29
+ "y": 30
},
"id": 31,
"options": {
@@ -965,9 +1079,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -1001,7 +1119,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1027,9 +1148,9 @@
},
"gridPos": {
"h": 8,
- "w": 6,
+ "w": 8,
"x": 8,
- "y": 29
+ "y": 30
},
"id": 34,
"options": {
@@ -1047,9 +1168,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -1083,7 +1208,10 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
@@ -1109,9 +1237,9 @@
},
"gridPos": {
"h": 8,
- "w": 6,
- "x": 14,
- "y": 29
+ "w": 8,
+ "x": 16,
+ "y": 30
},
"id": 35,
"options": {
@@ -1129,9 +1257,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"metricColumn": "none",
@@ -1165,17 +1297,16 @@
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
- "custom": {
- "align": "auto",
- "displayMode": "auto"
- },
"mappings": [],
"thresholds": {
"mode": "absolute",
@@ -1195,23 +1326,39 @@
},
"gridPos": {
"h": 8,
- "w": 4,
- "x": 20,
- "y": 29
+ "w": 8,
+ "x": 0,
+ "y": 38
},
- "id": 46,
+ "id": 36,
"options": {
- "showHeader": true
+ "colorMode": "value",
+ "graphMode": "area",
+ "justifyMode": "auto",
+ "orientation": "auto",
+ "reduceOptions": {
+ "calcs": [
+ "lastNotNull"
+ ],
+ "fields": "",
+ "values": false
+ },
+ "text": {},
+ "textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "select\n distinct author_name\nfrom \n\tpull_requests
pr\nwhere\n date(created_date) BETWEEN curdate() - INTERVAL
WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1
DAY\n\tand base_repo_id in ($repo_id)\n\tand author_name not in (select
distinct author_name from pull_requests where created_date < curdate() -
INTERVAL WEEKDAY(curdate())+7 DAY and author_name is not null)",
+ "rawSql": "select\n\tcount(*) as merged_pull_request_count\nfrom
\n\tpull_requests pr\nwhere\n date(created_date) BETWEEN curdate() - INTERVAL
WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1
DAY\n\tand base_repo_id in ($repo_id)\n\tand merged_date is not null\n\tand
author_id not in (select distinct id from accounts where organization in
($org))",
"refId": "A",
"select": [
[
@@ -1235,11 +1382,14 @@
]
}
],
- "title": "First time Contributor [Previous Week]",
- "type": "table"
+ "title": "Number of Merged Pull Requests Created by the Community
[Previous Week]",
+ "type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1256,20 +1406,21 @@
},
{
"color": "red",
- "value": 80
+ "value": 7
}
]
- }
+ },
+ "unit": "d"
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 8,
- "x": 0,
- "y": 37
+ "x": 8,
+ "y": 38
},
- "id": 36,
+ "id": 39,
"options": {
"colorMode": "value",
"graphMode": "area",
@@ -1285,15 +1436,19 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "select\n\tcount(*) as merged_pull_request_count\nfrom
\n\tpull_requests pr\nwhere\n date(created_date) BETWEEN curdate() - INTERVAL
WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1
DAY\n\tand base_repo_id in ($repo_id)\n\tand merged_date is not null\n\tand
author_id not in (select distinct id from accounts where organization in
($org))",
+ "rawSql":
"select\n\tavg(TIMESTAMPDIFF(Minute,created_date,merged_date)/1440)\nfrom
\n\tpull_requests\nwhere \n date(created_date) BETWEEN curdate() - INTERVAL
WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1
DAY\n\tand base_repo_id in ($repo_id)\n\tand merged_date is not null\n\tand
author_id not in (select distinct id from accounts where organization in
($org))",
"refId": "A",
"select": [
[
@@ -1317,11 +1472,125 @@
]
}
],
- "title": "Number of Merged Pull Requests Created by the Community
[Previous Week]",
+ "title": "Average Time to Merge of Community Pull Requests in Days
[Previous Week]",
"type": "stat"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
+ "description": "Contributors: the PR authors who have merged PR(s)",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "thresholds"
+ },
+ "custom": {
+ "align": "auto",
+ "cellOptions": {
+ "type": "auto"
+ },
+ "inspect": false
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green",
+ "value": null
+ },
+ {
+ "color": "red",
+ "value": 80
+ }
+ ]
+ }
+ },
+ "overrides": []
+ },
+ "gridPos": {
+ "h": 8,
+ "w": 8,
+ "x": 16,
+ "y": 38
+ },
+ "id": 46,
+ "options": {
+ "cellHeight": "sm",
+ "footer": {
+ "countRows": false,
+ "fields": "",
+ "reducer": [
+ "sum"
+ ],
+ "show": false
+ },
+ "showHeader": true
+ },
+ "pluginVersion": "9.5.1",
+ "targets": [
+ {
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
+ "editorMode": "code",
+ "format": "table",
+ "group": [],
+ "hide": false,
+ "metricColumn": "none",
+ "rawQuery": true,
+ "rawSql": "select\n distinct author_name\nfrom \n\tpull_requests
pr\nwhere\n date(created_date) BETWEEN curdate() - INTERVAL
WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1
DAY\n\tand merged_date is not null\n\tand base_repo_id in ($repo_id)\n\tand
author_name not in (select distinct author_name from pull_requests where
created_date < curdate() - INTERVAL WEEKDAY(curdate())+7 DAY and author_name is
not null)",
+ "refId": "A",
+ "select": [
+ [
+ {
+ "params": [
+ "id"
+ ],
+ "type": "column"
+ }
+ ]
+ ],
+ "sql": {
+ "columns": [
+ {
+ "parameters": [],
+ "type": "function"
+ }
+ ],
+ "groupBy": [
+ {
+ "property": {
+ "type": "string"
+ },
+ "type": "groupBy"
+ }
+ ],
+ "limit": 50
+ },
+ "table": "ae_projects",
+ "timeColumn": "ae_create_time",
+ "timeColumnType": "timestamp",
+ "where": [
+ {
+ "name": "$__timeFilter",
+ "params": [],
+ "type": "macro"
+ }
+ ]
+ }
+ ],
+ "title": "First time Contributor [Previous Week]",
+ "type": "table"
+ },
+ {
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1353,8 +1622,8 @@
"gridPos": {
"h": 8,
"w": 8,
- "x": 8,
- "y": 37
+ "x": 0,
+ "y": 46
},
"id": 37,
"options": {
@@ -1372,9 +1641,13 @@
"text": {},
"textMode": "auto"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"format": "table",
"group": [],
"hide": false,
@@ -1408,13 +1681,22 @@
"type": "stat"
},
{
- "datasource": "mysql",
- "description": "",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
+ "custom": {
+ "align": "auto",
+ "cellOptions": {
+ "type": "auto"
+ },
+ "inspect": false
+ },
"mappings": [],
"thresholds": {
"mode": "absolute",
@@ -1425,58 +1707,105 @@
},
{
"color": "red",
- "value": 3
+ "value": 7
}
]
},
- "unit": "d"
+ "unit": "none"
},
- "overrides": []
+ "overrides": [
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "title"
+ },
+ "properties": [
+ {
+ "id": "custom.width",
+ "value": 451
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "queue_time_in_days"
+ },
+ "properties": [
+ {
+ "id": "custom.cellOptions",
+ "value": {
+ "type": "color-text"
+ }
+ }
+ ]
+ }
+ ]
},
"gridPos": {
"h": 8,
- "w": 8,
- "x": 16,
- "y": 37
+ "w": 16,
+ "x": 8,
+ "y": 46
},
- "id": 39,
+ "id": 51,
"options": {
- "colorMode": "value",
- "graphMode": "area",
- "justifyMode": "auto",
- "orientation": "auto",
- "reduceOptions": {
- "calcs": [
- "lastNotNull"
- ],
+ "cellHeight": "sm",
+ "footer": {
+ "countRows": false,
"fields": "",
- "values": false
+ "reducer": [
+ "sum"
+ ],
+ "show": false
},
- "text": {},
- "textMode": "auto"
+ "showHeader": true,
+ "sortBy": []
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
+ "editorMode": "code",
"format": "table",
"group": [],
- "hide": false,
"metricColumn": "none",
+ "queryType": "randomWalk",
"rawQuery": true,
- "rawSql":
"select\n\tavg(TIMESTAMPDIFF(Minute,created_date,merged_date)/1440)\nfrom
\n\tpull_requests\nwhere \n date(created_date) BETWEEN curdate() - INTERVAL
WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1
DAY\n\tand base_repo_id in ($repo_id)\n\tand merged_date is not null\n\tand
author_id not in (select distinct id from accounts where organization in
($org))",
+ "rawSql": "select\n pull_request_key,\n title,\n status,\n
author_name,\n created_date,\n (TIMESTAMPDIFF(MINUTE,
created_date,curdate()))/1440 as queue_time_in_days,\n url\nfrom
\n\tpull_requests pr\nwhere\n date(created_date) BETWEEN curdate() - INTERVAL
WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL WEEKDAY(curdate())+1
DAY\n\tand base_repo_id in ($repo_id)\n\tand merged_date is null\n and
author_id not in (select distinct id from accounts where organization in
($org))",
"refId": "A",
"select": [
[
{
"params": [
- "id"
+ "script_version"
],
"type": "column"
}
]
],
- "table": "ae_projects",
- "timeColumn": "ae_create_time",
+ "sql": {
+ "columns": [
+ {
+ "parameters": [],
+ "type": "function"
+ }
+ ],
+ "groupBy": [
+ {
+ "property": {
+ "type": "string"
+ },
+ "type": "groupBy"
+ }
+ ],
+ "limit": 50
+ },
+ "table": "_devlake_migration_history",
+ "timeColumn": "created_at",
"timeColumnType": "timestamp",
"where": [
{
@@ -1487,11 +1816,14 @@
]
}
],
- "title": "Average Time to Merge of Community Pull Requests in Days
[Previous Week]",
- "type": "stat"
+ "title": "List of New Community Issues' 1st Comment [Previous Week]",
+ "type": "table"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1499,6 +1831,8 @@
"mode": "palette-classic"
},
"custom": {
+ "axisCenteredZero": false,
+ "axisColorMode": "text",
"axisLabel": "Merged PR Count",
"axisPlacement": "auto",
"axisSoftMin": 0,
@@ -1509,7 +1843,13 @@
"tooltip": false,
"viz": false
},
- "lineWidth": 1
+ "lineWidth": 1,
+ "scaleDistribution": {
+ "type": "linear"
+ },
+ "thresholdsStyle": {
+ "mode": "off"
+ }
},
"mappings": [],
"thresholds": {
@@ -1531,37 +1871,49 @@
},
"gridPos": {
"h": 9,
- "w": 12,
+ "w": 10,
"x": 0,
- "y": 45
+ "y": 54
},
"id": 33,
"options": {
+ "barRadius": 0,
"barWidth": 0.5,
+ "fullHighlight": false,
"groupWidth": 0.7,
"legend": {
"calcs": [],
"displayMode": "list",
- "placement": "bottom"
+ "placement": "bottom",
+ "showLegend": true
},
"orientation": "auto",
"showValue": "auto",
+ "stacking": "none",
"text": {
"valueSize": 12
},
"tooltip": {
- "mode": "multi"
- }
+ "mode": "multi",
+ "sort": "none"
+ },
+ "xTickLabelRotation": 45,
+ "xTickLabelSpacing": 0
},
"pluginVersion": "8.0.6",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
+ "editorMode": "code",
"format": "table",
"group": [],
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "select\n author_name,\n\tcount(*) as
pull_request_count\nfrom \n\tpull_requests pr\nwhere\n date(created_date)
BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL
WEEKDAY(curdate())+1 DAY\n\tand base_repo_id in ($repo_id)\n\tand author_id not
in (select distinct id from accounts where organization in ($org))\ngroup by
1\norder by 2 desc\nlimit 20\n",
+ "rawSql": "select\n author_name,\n\tcount(*) as
pull_request_count\nfrom \n\tpull_requests pr\nwhere\n date(created_date)
BETWEEN curdate() - INTERVAL WEEKDAY(curdate())+7 DAY AND curdate() - INTERVAL
WEEKDAY(curdate())+1 DAY\n\tand base_repo_id in ($repo_id)\n\tand merged_date
is not NULL\n\tand author_id not in (select distinct id from accounts where
organization in ($org))\ngroup by 1\norder by 2 desc\nlimit 20\n",
"refId": "A",
"select": [
[
@@ -1573,6 +1925,23 @@
}
]
],
+ "sql": {
+ "columns": [
+ {
+ "parameters": [],
+ "type": "function"
+ }
+ ],
+ "groupBy": [
+ {
+ "property": {
+ "type": "string"
+ },
+ "type": "groupBy"
+ }
+ ],
+ "limit": 50
+ },
"table": "ae_projects",
"timeColumn": "ae_create_time",
"timeColumnType": "timestamp",
@@ -1585,11 +1954,14 @@
]
}
],
- "title": "Top Community Contributors By Number of PRs Created [Previous
Week]",
+ "title": "Top 20 Community Contributors By Number of PRs Merged
[Previous Week]",
"type": "barchart"
},
{
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"description": "",
"fieldConfig": {
"defaults": {
@@ -1598,15 +1970,113 @@
},
"mappings": [],
"thresholds": {
- "mode": "percentage",
+ "mode": "absolute",
"steps": [
{
"color": "green",
"value": null
- },
+ }
+ ]
+ }
+ },
+ "overrides": []
+ },
+ "gridPos": {
+ "h": 9,
+ "w": 6,
+ "x": 10,
+ "y": 54
+ },
+ "id": 52,
+ "options": {
+ "colorMode": "value",
+ "graphMode": "area",
+ "justifyMode": "auto",
+ "orientation": "auto",
+ "reduceOptions": {
+ "calcs": [
+ "lastNotNull"
+ ],
+ "fields": "",
+ "values": false
+ },
+ "textMode": "auto"
+ },
+ "pluginVersion": "9.5.1",
+ "targets": [
+ {
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
+ "editorMode": "code",
+ "format": "table",
+ "group": [],
+ "hide": false,
+ "metricColumn": "none",
+ "rawQuery": true,
+ "rawSql": "select\n\tcount(distinct author_id) as
all_contributor_count\nfrom \n\tpull_requests pr\nwhere\n\tbase_repo_id in
($repo_id)\n\tand merged_date is not null\n\t-- and author_id not in (select
distinct id from accounts where organization in ($org))\n",
+ "refId": "A",
+ "select": [
+ [
{
- "color": "red",
- "value": 80
+ "params": [
+ "id"
+ ],
+ "type": "column"
+ }
+ ]
+ ],
+ "sql": {
+ "columns": [
+ {
+ "parameters": [],
+ "type": "function"
+ }
+ ],
+ "groupBy": [
+ {
+ "property": {
+ "type": "string"
+ },
+ "type": "groupBy"
+ }
+ ],
+ "limit": 50
+ },
+ "table": "ae_projects",
+ "timeColumn": "ae_create_time",
+ "timeColumnType": "timestamp",
+ "where": [
+ {
+ "name": "$__timeFilter",
+ "params": [],
+ "type": "macro"
+ }
+ ]
+ }
+ ],
+ "title": "Top Community Contributors By PRs Created [All History]",
+ "type": "stat"
+ },
+ {
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "thresholds"
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green",
+ "value": null
}
]
},
@@ -1616,13 +2086,15 @@
},
"gridPos": {
"h": 9,
- "w": 12,
- "x": 12,
- "y": 45
+ "w": 8,
+ "x": 16,
+ "y": 54
},
"id": 40,
"options": {
"displayMode": "gradient",
+ "minVizHeight": 10,
+ "minVizWidth": 0,
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
@@ -1634,17 +2106,23 @@
"showUnfilled": true,
"text": {
"valueSize": 1
- }
+ },
+ "valueMode": "color"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
+ "editorMode": "code",
"format": "table",
"group": [],
"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 author_id
not in (select distinct id from accounts where organization in ($org))\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\tbase_repo_id in
($repo_id)\n\tand merged_date is not NULL\n\t-- and author_id not in (select
distinct id from accounts where organization in ($org))\ngroup by 1\norder by 2
desc\nlimit 20\n",
"refId": "A",
"select": [
[
@@ -1656,6 +2134,23 @@
}
]
],
+ "sql": {
+ "columns": [
+ {
+ "parameters": [],
+ "type": "function"
+ }
+ ],
+ "groupBy": [
+ {
+ "property": {
+ "type": "string"
+ },
+ "type": "groupBy"
+ }
+ ],
+ "limit": 50
+ },
"table": "ae_projects",
"timeColumn": "ae_create_time",
"timeColumnType": "timestamp",
@@ -1668,25 +2163,37 @@
]
}
],
- "title": "Top Community Contributors By PRs Created [All History]",
+ "title": "Top 20 Community Contributors By Merged PR Numbers [All
History]",
"type": "bargauge"
},
{
- "datasource": null,
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"gridPos": {
"h": 2,
"w": 24,
"x": 0,
- "y": 54
+ "y": 63
},
"id": 50,
"options": {
+ "code": {
+ "language": "plaintext",
+ "showLineNumbers": false,
+ "showMiniMap": false
+ },
"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/Configuration/Dashboards/GrafanaUserGuide).",
"mode": "markdown"
},
- "pluginVersion": "8.0.6",
+ "pluginVersion": "9.5.1",
"targets": [
{
+ "datasource": {
+ "type": "datasource",
+ "uid": "grafana"
+ },
"queryType": "randomWalk",
"refId": "A"
}
@@ -1695,13 +2202,12 @@
}
],
"refresh": "",
- "schemaVersion": 30,
+ "schemaVersion": 38,
"style": "dark",
"tags": [],
"templating": {
"list": [
{
- "allValue": null,
"current": {
"selected": true,
"text": [
@@ -1711,10 +2217,11 @@
"$__all"
]
},
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"definition": "select concat(name, '-', id) as text from repos",
- "description": null,
- "error": null,
"hide": 0,
"includeAll": true,
"label": "Repo",
@@ -1729,16 +2236,16 @@
"type": "query"
},
{
- "allValue": null,
"current": {
"selected": false,
"text": "All",
"value": "$__all"
},
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"definition": "select distinct type from issues",
- "description": null,
- "error": null,
"hide": 0,
"includeAll": true,
"label": "Issue Type",
@@ -1753,7 +2260,6 @@
"type": "query"
},
{
- "allValue": null,
"current": {
"selected": true,
"text": [
@@ -1763,10 +2269,12 @@
"$__all"
]
},
- "datasource": "mysql",
+ "datasource": {
+ "type": "mysql",
+ "uid": "P430005175C4C7810"
+ },
"definition": "select distinct organization from accounts where
organization != ''",
"description": "",
- "error": null,
"hide": 0,
"includeAll": true,
"label": "Community Definition - Issues and PRs NOT from
Organization(s)",
@@ -1790,5 +2298,6 @@
"timezone": "",
"title": "Weekly Community Retro",
"uid": "VTr6Y_q7z",
- "version": 3
+ "version": 9,
+ "weekStart": ""
}
\ No newline at end of file
