Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,435
Community Members
 
Community Events
165
Community Groups

Ability to generate reports with easy to adjust date ranges

I feel like this shouldn't be as hard as it is but we want to report on more than just sprint data and we're hitting some blockers. Ideally I'd like to be able to generate a range of reports such as:

- % split of issues in done by issue type (eg. bug, story, task) visualized as a pie chart

- % split of issues completed by project (eg. Features, Operations, Marketing) as a pie chart

- % of issues that pass/fail user testing

- Story points completed over a date range with the ability to compare

Now I can achieve all of this with static queries but we want to be able to easily change date ranges and compare data which is proving difficult.

I've evaluated so far:

- Issue analysis pie chart based off JQL query in a confluence document (lacks ability to easily manipulate date ranges and compare)

- Jira to quicksight integration - Does not pull through many key or custom fields

- Jira to Airtable integration - Does not pull through many key fields (namely labels) or custom fields and requires pro tier to just get pie charts as an option.

- EazyBI for Jira - Had a quick play and it felt limited but could do with more investigation.

 

I just want to ask, am I missing something incredibly obvious. I just feel like being able to adjust date ranges and compare data for reporting in 2022 is not a massive ask. 

2 answers

2 votes
Jack Brickey Community Leader Jun 20, 2022

Hi @William Chambers ,

there are some gadgets that allow manipulation of date ranges. I think, but unsure, that custom-charts-for-jira can do this. I also think EasyBI can.

Other OOTB options include using the official extension for Excel or Sheets and create your analysis outside of Jira or connect to Microsoft PowerBI off that is an option.

Yeah I saw a good youtube demo for custom charts for jira so that could be a good option, definitely ticks the box of not having to dig back into JQL queries for manipulating simple data points. Thanks mate!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

92 views 1 3
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you