Ability to generate reports with easy to adjust date ranges

[William Chambers]

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. 

[Jack Brickey]

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.

[William Chambers]

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!