Startrekzky commented on issue #6263: URL: https://github.com/apache/incubator-devlake/issues/6263#issuecomment-1882409363
> Yes, issue logs are getting collected. In below example, we would like to consider time between when original_to_value changed to In Dev and changed to In QA. Current report is referring time between ticket created and to_value changed to DONE. When we refer status it is just considering TODO, IN_PROGRESS & DONE. Hi @dwaghulade . In your case, you have to write your own query to get the result. The logical steps are: 1. Join table [issues](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema#issues) with table [issue_changelogs](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema#issue_changelogs) to get all issues' time of transitioning to 'In Dev' and time of transitioning to 'In QA'. 2. Diff the two time-fields to get the lead time of every issue 3. Calculate the median lead time of all issues It's a complicated SQL so you can follow the [data schema](https://devlake.apache.org/docs/DataModels/DevLakeDomainLayerSchema#issue_changelogs) and [metric examples](https://devlake.apache.org/docs/Metrics/RequirementLeadTime#how-is-it-calculated) to figure it out. -- 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]
