You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by zk...@apache.org on 2024/01/24 06:32:43 UTC
(incubator-devlake) branch main updated: fix: issue story points dashboard (#6866)
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 86c4ed903 fix: issue story points dashboard (#6866)
86c4ed903 is described below
commit 86c4ed90353a5c0621583a309c739ed4963d3ed9
Author: abeizn <zi...@merico.dev>
AuthorDate: Wed Jan 24 14:32:38 2024 +0800
fix: issue story points dashboard (#6866)
---
grafana/dashboards/EngineeringThroughputAndCycleTime.json | 7 +++----
1 file changed, 3 insertions(+), 4 deletions(-)
diff --git a/grafana/dashboards/EngineeringThroughputAndCycleTime.json b/grafana/dashboards/EngineeringThroughputAndCycleTime.json
index eed7cbad2..2b452200f 100644
--- a/grafana/dashboards/EngineeringThroughputAndCycleTime.json
+++ b/grafana/dashboards/EngineeringThroughputAndCycleTime.json
@@ -18,7 +18,7 @@
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
- "id": 17,
+ "id": 20,
"links": [],
"liveNow": false,
"panels": [
@@ -351,7 +351,6 @@
"pluginVersion": "8.0.6",
"targets": [
{
-
"format": "table",
"group": [],
"hide": false,
@@ -477,7 +476,7 @@
"hide": false,
"metricColumn": "none",
"rawQuery": true,
- "rawSql": "SELECT\n DATE_ADD(date(i.resolution_date), INTERVAL -$interval(date(i.resolution_date))+1 DAY) as time,\n sum(case when i.status = 'DONE' then i.story_point else 0 end) as 'Story Points Completed',\n i.id\nFROM issues i\n\tjoin board_issues bi on i.id = bi.issue_id\n\tjoin boards b on bi.board_id = b.id\n\tjoin project_mapping pm on b.id = pm.row_id\nWHERE\n $__timeFilter(i.resolution_date)\n and pm.project_name in ($project)\ngroup by 1,3\norder by 1",
+ "rawSql": "SELECT\n DATE_ADD(date(i.resolution_date), INTERVAL -$interval(date(i.resolution_date))+1 DAY) as time,\n sum(case when i.status = 'DONE' then i.story_point else 0 end) as 'Story Points Completed'\nFROM (\n SELECT DISTINCT i.id, i.resolution_date, i.status, i.story_point\n FROM issues i\n join board_issues bi on i.id = bi.issue_id\n join boards b on bi.board_id = b.id\n join project_mapping pm on b.id = pm.row_id\n WHERE\n $__timeFilter(i.resolution_ [...]
"refId": "A",
"select": [
[
@@ -1873,6 +1872,6 @@
"timezone": "",
"title": "Engineering Throughput and Cycle Time",
"uid": "Jaaimc67k",
- "version": 3,
+ "version": 1,
"weekStart": ""
}
\ No newline at end of file