Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

how do i create custom report in Jira?

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?

3 answers

@Gowtham B

Hi,

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.

Thomas Bowskill Community Leader May 16, 2018

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).

Thomas Bowskill Community Leader May 16, 2018

There is a JIRA macro in Confluence: https://confluence.atlassian.com/doc/jira-issues-macro-139380.html

In this you can either write JQL or load in an existing filter

@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.

@Иван Кузнецов

 

can i generate bar-chart report automatically using that JIRA data?

@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:

Untitled2.png

From Arsenale Dataplane Report you will receive PDF reporter with detailed information like this:Untitled.png

 

There is a lot of report types in Arsenale:

Untitled3.png

@Gowtham BAdditionally you can try default Jira Service Desk reports. For my requirements it was lack in connection of low configuration.

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,

https://github.com/KoderLabs/jira-powerbi-template

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. 

Hi,

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:

https://eazybi.com/accounts/1000/dashboards/4553-jira-issues-dashboard

You can start your trial from the Atlassian Marketplace for Jira Server:

https://marketplace.atlassian.com/apps/1211051/eazybi-reports-and-charts-for-jira?hosting=server&tab=overview

or Jira Cloud:

https://marketplace.atlassian.com/apps/1211508/eazybi-reports-and-charts-for-jira-cloud?hosting=cloud&tab=overview

and contact support when some questions arise.

 

Kindly,

Janis, eazyBI support

Hi,

I am not able to install trial version of eazyBI. I am getting error like java exception has occurred

You'll need to read your logs and look at the error to see what the problem is.  "Java exception" only tells us "something broke", we can't diagnose anything from that.

@Gowtham B please, contact eazyBI support for such cases. We will definitely look in more details on the issues with add-on installation.

Kindly,

Janis

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Send an Email or Publish to Confluence - What should you do with your release notes?

Background When you hear the words ‘Release notes’, almost always you think of an unsolicited email from a software vendor. But I am here to tell you that from our data, sending release notes via E...

37 views 0 1
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