I am generating minor enhancements report every week using JIRA data. I am using some filters in excel sheet to generate it. its an old model that we are using to generate report. we are tired of working in excel sheet. so i have to automate it. is there any possibilities to generate automatic report from selective fields of jira data?
You can subscribe to Jira filter, for receiving automatically generated report in defined periods.
I am using confluence pages with included JIRA filters to build reports. You can input defined Jira filter in to page and it will be dynamically.
The second way, which i like - addon Arsenale Dataplane. There are a lot of different report types, you can try trial version for 30 days.
I embed on Confluence pages too. If the information can be given real-time and you just want to display the tabular data (with no calculations) then it's easier to manage this way.
If you want to calculate things with that data then I think you need to start looking at Apps (e.g. I think EasyBI is something in that vein -- something on my radar but I haven't played with it).
@Gowtham BYou have to create and save your JQL filter. After that you have to go: Issues-Manage Filters. In right screen side you will find Subscribe buttons vs every saved filter. If you click Subcribe, system will display screen, where you can configure report period and subscribers.
@Gowtham BDepends of way, which you will choose. You can find an examples below.
Anyway, solution depends of report requirements. For example, if you have to create composite report with few bars or diagramms with different filters - you have to implement completely different system, which will hook data from JIRA and construct your report. This is more expensive solution.
If task is more simple you can try Arsenale or Confluence(including addons for diagrams) or other addons for build it. This is less expensive solution, but maybe requires some manuall actions each times.
Subscription to JQL filter - there is only Issue list, which you will peridiocally receive via mail:
From Arsenale Dataplane Report you will receive PDF reporter with detailed information like this:
There is a lot of report types in Arsenale:
eazyBI is definitely an option to try out for creating advanced and automated reporting from the Jira data. You can check some of the report examples on the public demo account:
You can start your trial from the Atlassian Marketplace for Jira Server:
or Jira Cloud:
and contact support when some questions arise.
Janis, eazyBI support
This has been my biggest frustration, but then I was able to connect Jira with Power BI using Jira APIs. I have made it opensource and you can get it from here,
Using Power BI, you can create all sort of reports you want without much hassle, that too for free. Before going with Power BI, I tried creating a plugin, but creating a plugin for every report takes too much time and is too much hassle to manage a lot of reports.
Feel free to use it and give feedback.
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
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