This is an automated email from the ASF dual-hosted git repository.
klesh 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 c8efd1ff fix: some dashboard panels can not show. (#2817)
c8efd1ff is described below
commit c8efd1ff26eecc59a68773fdc1d17f390df586bd
Author: abeizn <[email protected]>
AuthorDate: Wed Aug 24 14:46:27 2022 +0800
fix: some dashboard panels can not show. (#2817)
* fix: some dashboard panels can not show.
* fix: some dashboard panels can not show
---
grafana/_archive/Daily_Needs_To_Be_Improved.json | 389 +++++++++++++++++++++
...itHubReleaseQualityAndContributionAnalysis.json | 8 +-
...ithubReleaseQualityAndContributionAnalysis.json | 8 +-
3 files changed, 397 insertions(+), 8 deletions(-)
diff --git a/grafana/_archive/Daily_Needs_To_Be_Improved.json
b/grafana/_archive/Daily_Needs_To_Be_Improved.json
new file mode 100644
index 00000000..7cbeec99
--- /dev/null
+++ b/grafana/_archive/Daily_Needs_To_Be_Improved.json
@@ -0,0 +1,389 @@
+{
+ "annotations": {
+ "list": [
+ {
+ "builtIn": 1,
+ "datasource": "-- Grafana --",
+ "enable": true,
+ "hide": true,
+ "iconColor": "rgba(0, 211, 255, 1)",
+ "name": "Annotations & Alerts",
+ "type": "dashboard"
+ }
+ ]
+ },
+ "description": "",
+ "editable": true,
+ "gnetId": null,
+ "graphTooltip": 0,
+ "id": 32,
+ "iteration": 1661321745952,
+ "links": [],
+ "panels": [
+ {
+ "datasource": null,
+ "gridPos": {
+ "h": 4,
+ "w": 24,
+ "x": 0,
+ "y": 0
+ },
+ "id": 57,
+ "options": {
+ "content": "- Use Cases: This dashboard can be used to track bugs.\n-
Data Source Required: GitHub
([transformation](https://devlake.apache.org/docs/UserManuals/ConfigUI/GitHub#step-3---adding-transformation-rules-optional)
required. Additional settings are required to get version data).",
+ "mode": "markdown"
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "queryType": "randomWalk",
+ "refId": "A"
+ }
+ ],
+ "title": "Dashboard Introduction",
+ "type": "text"
+ },
+ {
+ "datasource": "mysql",
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
+ },
+ "custom": {
+ "hideFrom": {
+ "legend": false,
+ "tooltip": false,
+ "viz": false
+ }
+ },
+ "mappings": [],
+ "unit": "none"
+ },
+ "overrides": [
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "label_name"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "semi-dark-green",
+ "mode": "fixed"
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "count"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "red",
+ "mode": "palette-classic"
+ }
+ }
+ ]
+ }
+ ]
+ },
+ "gridPos": {
+ "h": 6,
+ "w": 7,
+ "x": 0,
+ "y": 4
+ },
+ "id": 59,
+ "options": {
+ "displayLabels": [
+ "name",
+ "percent"
+ ],
+ "legend": {
+ "displayMode": "hidden",
+ "placement": "right",
+ "values": [
+ "value",
+ "percent"
+ ]
+ },
+ "pieType": "donut",
+ "reduceOptions": {
+ "calcs": [
+ "lastNotNull"
+ ],
+ "fields": "",
+ "values": true
+ },
+ "tooltip": {
+ "mode": "multi"
+ }
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "format": "table",
+ "group": [],
+ "metricColumn": "none",
+ "queryType": "randomWalk",
+ "rawQuery": true,
+ "rawSql": "select \ndistinct il.label_name, count(il.label_name) as
count\nfrom \nissues i\nleft join issue_labels il on i.id = il.issue_id\nwhere
i.type = \"BUG\" and il.label_name like \"%O-%\" and i.updated_date >
\"2021-08-01 00:00:00.000\"\ngroup by il.label_name\n",
+ "refId": "A",
+ "select": [
+ [
+ {
+ "params": [
+ "id"
+ ],
+ "type": "column"
+ }
+ ]
+ ],
+ "table": "ae_projects",
+ "timeColumn": "ae_create_time",
+ "timeColumnType": "timestamp",
+ "where": [
+ {
+ "name": "$__timeFilter",
+ "params": [],
+ "type": "macro"
+ }
+ ]
+ }
+ ],
+ "title": "01. Bug Source",
+ "type": "piechart"
+ },
+ {
+ "datasource": "mysql",
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "thresholds"
+ },
+ "custom": {
+ "align": "auto",
+ "displayMode": "auto"
+ },
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green",
+ "value": null
+ },
+ {
+ "color": "red",
+ "value": 80
+ }
+ ]
+ },
+ "unit": "none"
+ },
+ "overrides": [
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "<avg_bug_age"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "semi-dark-green",
+ "mode": "fixed"
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": ">=avg_bug_age"
+ },
+ "properties": [
+ {
+ "id": "color",
+ "value": {
+ "fixedColor": "red",
+ "mode": "fixed"
+ }
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "issue_key"
+ },
+ "properties": [
+ {
+ "id": "custom.width",
+ "value": 81
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "title"
+ },
+ "properties": [
+ {
+ "id": "custom.width",
+ "value": 535
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "created_date"
+ },
+ "properties": [
+ {
+ "id": "custom.width",
+ "value": 149
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "queue_time_in_days"
+ },
+ "properties": [
+ {
+ "id": "custom.width",
+ "value": 140
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "issue_url"
+ },
+ "properties": [
+ {
+ "id": "custom.width",
+ "value": 399
+ }
+ ]
+ },
+ {
+ "matcher": {
+ "id": "byName",
+ "options": "sha"
+ },
+ "properties": [
+ {
+ "id": "custom.width",
+ "value": 328
+ }
+ ]
+ }
+ ]
+ },
+ "gridPos": {
+ "h": 6,
+ "w": 17,
+ "x": 7,
+ "y": 4
+ },
+ "id": 61,
+ "options": {
+ "showHeader": true,
+ "sortBy": []
+ },
+ "pluginVersion": "8.0.6",
+ "targets": [
+ {
+ "format": "table",
+ "group": [],
+ "metricColumn": "none",
+ "queryType": "randomWalk",
+ "rawQuery": true,
+ "rawSql": "with issue_sha_deveq as(\nselect\ni.url as issue_url,
c.sha, c.dev_eq\nfrom \npull_request_issues pri\nleft join pull_request_commits
prc on prc.pull_request_id = pri.pull_request_id\nleft join issues i on
pri.issue_id = i.id\nleft join commits c on c.sha = prc.commit_sha\nwhere
i.type = \"BUG\" and i.status = \"DONE\" and c.sha != \"\" and c.committed_date
> \"2021-08-01 00:00:00.000\"\n)\n\nselect\nissue_url, sum(dev_eq) as
dev_eq_total\nfrom\nissue_sha_deveq\ngrou [...]
+ "refId": "A",
+ "select": [
+ [
+ {
+ "params": [
+ "id"
+ ],
+ "type": "column"
+ }
+ ]
+ ],
+ "table": "ae_projects",
+ "timeColumn": "ae_create_time",
+ "timeColumnType": "timestamp",
+ "where": [
+ {
+ "name": "$__timeFilter",
+ "params": [],
+ "type": "macro"
+ }
+ ]
+ }
+ ],
+ "title": "02. Bug Dev_eq",
+ "type": "table"
+ }
+ ],
+ "refresh": "",
+ "schemaVersion": 30,
+ "style": "dark",
+ "tags": [],
+ "templating": {
+ "list": [
+ {
+ "allValue": null,
+ "current": {
+ "selected": true,
+ "text": [
+ "All"
+ ],
+ "value": [
+ "$__all"
+ ]
+ },
+ "datasource": null,
+ "definition": "select concat(name, '--', id) as text from repos",
+ "description": null,
+ "error": null,
+ "hide": 0,
+ "includeAll": true,
+ "label": "Repo",
+ "multi": true,
+ "name": "repo_id",
+ "options": [],
+ "query": "select concat(name, '--', id) as text from repos",
+ "refresh": 1,
+ "regex": "/^(?<text>.*)--(?<value>.*)$/",
+ "skipUrlSync": false,
+ "sort": 0,
+ "type": "query"
+ }
+ ]
+ },
+ "time": {
+ "from": "now-6M",
+ "to": "now"
+ },
+ "timepicker": {},
+ "timezone": "",
+ "title": "Daily_Needs_To_Be_Improved",
+ "uid": "2xuOaQUnk5",
+ "version": 25
+}
\ No newline at end of file
diff --git
a/grafana/_archive/EeGitHubReleaseQualityAndContributionAnalysis.json
b/grafana/_archive/EeGitHubReleaseQualityAndContributionAnalysis.json
index 2b825649..b6e1d3f0 100644
--- a/grafana/_archive/EeGitHubReleaseQualityAndContributionAnalysis.json
+++ b/grafana/_archive/EeGitHubReleaseQualityAndContributionAnalysis.json
@@ -230,7 +230,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n distinct SUBSTRING_INDEX(new_ref_id,':', -1)
as new_ref_id, SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n --
distinct new_ref_id, old_ref_id\n FROM \n refs_commits_diffs\n
WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in ($repo_id)\n\tORDER BY 1
desc\n\tLIMIT 5\n),\n\n_bugs_of_tags as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_name, \n\t\t- [...]
+ "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n distinct SUBSTRING_INDEX(new_ref_id,':', -1)
as new_ref_id, SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n --
distinct new_ref_id, old_ref_id\n FROM \n refs_commits_diffs\n
WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in ($repo_id)\n\tORDER BY 1
desc\n\tLIMIT 5\n),\n\n_bugs_of_tags as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_name, \n\t\t- [...]
"refId": "A",
"select": [
[
@@ -2306,7 +2306,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1\n),\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_request [...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1\n),\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_request [...]
"refId": "A",
"select": [
[
@@ -2391,7 +2391,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_req [...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_req [...]
"refId": "A",
"select": [
[
@@ -2507,7 +2507,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 2,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_req [...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 3) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 2,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_req [...]
"refId": "A",
"select": [
[
diff --git
a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
index 9edddbd0..3963782d 100644
--- a/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
+++ b/grafana/dashboards/GithubReleaseQualityAndContributionAnalysis.json
@@ -242,7 +242,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n distinct SUBSTRING_INDEX(new_ref_id,':', -1)
as new_ref_id, SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n --
distinct new_ref_id, old_ref_id\n FROM \n refs_commits_diffs\n
WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in ($repo_id)\n\tORDER BY 1
desc\n\tLIMIT 5\n),\n\n_bugs_of_tags as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_name, \n\t\t- [...]
+ "rawSql": "-- Get the number of fixed bugs in the last 5 tags\nwith
_last_5_tags as(\n SELECT \n distinct SUBSTRING_INDEX(new_ref_id,':', -1)
as new_ref_id, SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n --
distinct new_ref_id, old_ref_id\n FROM \n refs_commits_diffs\n
WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in ($repo_id)\n\tORDER BY 1
desc\n\tLIMIT 5\n),\n\n_bugs_of_tags as(\n\tselect
\n\t\tSUBSTRING_INDEX(rid.new_ref_id,'tags/', -1) as tag_name, \n\t\t- [...]
"refId": "A",
"select": [
[
@@ -2139,7 +2139,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1\n),\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_request [...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1\n),\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_request [...]
"refId": "A",
"select": [
[
@@ -2255,7 +2255,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_req [...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 1,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_req [...]
"refId": "A",
"select": [
[
@@ -2371,7 +2371,7 @@
"metricColumn": "none",
"queryType": "randomWalk",
"rawQuery": true,
- "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 2,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_req [...]
+ "rawSql": "-- Get the work-type distribution in the last 5
tags\nwith _last_5_tags as(\n SELECT \n -- distinct new_ref_id,
old_ref_id\n distinct SUBSTRING_INDEX(new_ref_id,':', -1) as new_ref_id,
SUBSTRING_INDEX(old_ref_id,':', -1) as old_ref_id\n FROM \n
refs_commits_diffs\n WHERE\n\t\tSUBSTRING_INDEX(new_ref_id,':', 4) in
($repo_id)\n\tORDER BY 1 desc\n\tLIMIT 2,1\n),\n\n\n_combine_pr as (\n select
pull_request_id as id, commit_sha, p.pull_request_key as pull_req [...]
"refId": "A",
"select": [
[
