(incubator-devlake) branch release-v0.20 updated: fix: issue story points dashboard (#6866) (#6868)

[abeizn]

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] 
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Jan 24 14:33:28 2024 +0800

    fix: issue story points dashboard (#6866) (#6868)
    
    Co-authored-by: abeizn <zikuan...@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": ""
 }