You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by ab...@apache.org on 2024/01/24 06:33:32 UTC
(incubator-devlake) branch release-v0.20 updated: fix: issue story points dashboard (#6866) (#6868)
This is an automated email from the ASF dual-hosted git repository.
abeizn pushed a commit to branch release-v0.20
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/release-v0.20 by this push:
new 0d7a27eb5 fix: issue story points dashboard (#6866) (#6868)
0d7a27eb5 is described below
commit 0d7a27eb5007ee52d72c94bfe8e07a6615a9e74a
Author: github-actions[bot] <41...@users.noreply.github.com>
AuthorDate: Wed Jan 24 14:33:28 2024 +0800
fix: issue story points dashboard (#6866) (#6868)
Co-authored-by: abeizn <zi...@merico.dev>
---
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 a306f2683..4e282b29f 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": [
@@ -336,7 +336,6 @@
"pluginVersion": "9.5.15",
"targets": [
{
-
"format": "table",
"group": [],
"hide": false,
@@ -455,7 +454,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": [
[
@@ -1788,6 +1787,6 @@
"timezone": "",
"title": "Engineering Throughput and Cycle Time",
"uid": "Jaaimc67k",
- "version": 3,
+ "version": 1,
"weekStart": ""
}