This is an automated email from the ASF dual-hosted git repository. github-bot pushed a commit to branch release-v0.20-auto-cherry-pick-6866 in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
commit 5477017badc5c54fa941783217df2cc06d2e2125 Author: abeizn <[email protected]> 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 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": "" }
