I need a Jira Expression that tells me how much time a user spent on specific grouping of statuses. i.e. If I want to get the time while in dev then I want the work hours spent between New and In Progress. Another would be while a status is in QA so if it QA Ready to QA Passed and any statuses in between.
I know that this is hard and was told that the best way to do this is with the logic of:
- Loop through the changelog and get intervals (start and end timestamps) when the issue was in "X" status.
- Loop through worklogs and sum up the timeSpent for worklogs that fall into those intervals.
Is anyone good enough with Expressions that can help. And no I can't use Scriptrunner to do this.
