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
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.