Create report with grouped time ranges

Alexandra
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 9, 2018

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?

 

1 answer

0 votes
Earl McCutcheon
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 10, 2018

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events