Create report with grouped time ranges

Alexandra_d5rb3p

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?

 

Earl McCutcheon

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