Startrekzky commented on issue #5197:
URL:
https://github.com/apache/incubator-devlake/issues/5197#issuecomment-1549482919
I think changing `created_date` to `resolution_date` is acceptable if the
users' purpose is to measure the issues that have been finished, rather than
issues created within a timeframe that are finished.
Also, I found something else to improve in this SQL. Please see below:
```
SELECT
DATE_ADD(date(i.resolution_date), INTERVAL
-$interval(date(i.resolution_date))+1 DAY) as time,
sum(case when i.status = ‘DONE’ then i.story_point else 0 end) as ‘Story
Points Completed’
FROM issues i
join board_issues bi on i.id = bi.issue_id
join boards b on bi.board_id = b.id
join project_mapping pm on b.id = pm.row_id and pm.`table` = 'boards'
WHERE
$__timeFilter(i.resolution_date)
and pm.project_name in ($project)
group by 1
order by 1
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
