Hi - I'm looking to get a count of the number of issues across statuses for a given project over a given time range (can be dynamic or static). Haven't really seen any widgets or JQL scripts that can do this but any advice is appreciated.
Hi @martin_lau and welcome to the Community!
Have you looked at the Cumulative Flow Diagram associated with your project board?
Hope this helps!
Hey Walter, thanks for the warm welcome.
I did take a look at the CFD report functionality but it unfortunately does not take into the count of tickets that have not moved across statuses.
My current fix is to build a 2DF widget based on the JQL filter query below:
project = XXX AND status = "XXX" AND status changed before "YYYY-MM-DD"
Let me know if the query above correctly isolates/returns the count of tickets that are currently in a given status and changed to it before a set date regardless of when they entered the state (as long as they were in this state during the given period).
i.e. project = XXX AND status = "READY FOR DEV" AND status changed before "2024-09-30"
Would it be correct to presume that this filter returns tickets that are currently in the "READY FOR DEV" status and changed to it before September 30, 2024, regardless of when they entered the state (as long as they were in this state during the given period).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @martin_lau,
With that query you may still have corner cases, but it will probably be correct 95% of the time.
Your JQL statement says that:
but it does not specify what transition this was and it does not say anything about any status changes on or after Sept 30th. So if an issue changed from To Do to In Progress on Sept 10th and then was transitioned to Ready for Dev on Sept 30th at 11.30 AM, this will also be returned by your current filter.
So, depending on your requirements, you can still refine your query if necessary, e.g. by adding criteria like this:
project = XXX AND status = "READY FOR DEV" AND status CHANGED TO "READY
FOR DEV" before "2024-09-30"
That would make your transition into the given status even more specific.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.