Hi guys,
I've been looking through documentation for a while and fiddling around with queries, but I'm not sure how to achieve this. I want a graph showing, per month, how many workdays all issues spent in the open status for that month and that month only. I have a chart that shows time in open status, but this counts the number of workdays from when the issue was opened, and not sure the start of that particular month. Essentially, I don't want carry over from previous months. So for issues created that month, it would be how long they have spent in open since being created (those issues may still be open, or could be closed that month). For issues created in previous months, it would only count how much time they spent open since the start of the month.
I also have a resolution workdays chart which shows the total number of workdays all issues closed that month spent before being resolved, but again, this includes time before each month. Also, this only counts issues that have been resolved.
Apologies if I'm not explaining clearly enough, if you need any clarification just ask.
Thanks in advance :)
