I would like to create a report/ bar chart that shows me all issues that were created and accepted but not resolved yet. I would like to group these by their created date, i.e.
open and unresolved for >1 week
open and unresolved for >1 month
open and unresolved for >3 months
I can manage to group them into weeks or to filter, but I cannot get the combination of grouping and the specific date ranges. Can someone please help?
Hello Alexandra,
Natively the bar charts in jira are only going to have set date variables on an increment such as monthly, weekly or daily.
To achieve the custom date range groupings I would recomend looking a the Add-on Multiple Filters Chart Gadget and define three filters for your open issues in the defined ranges using something like the following referencing Advanced searching - functions reference:
open and unresolved for >1 week
resolution is EMPTY AND created <= startOfWeek()
open and unresolved for >1 month
resolution is EMPTY AND created <= startOfMonth()
open and unresolved for >3 months
resolution is EMPTY AND created <= startOfMonth(-3)
The Use the three filters on the Multiple Filters Bar Chart Gadget as detailed here
Regards,
Earl
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.