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,297,994
Community Members
 
Community Events
165
Community Groups

Wanted: Report App (Alternative to EazyBI)

Edited

Hi,

we have implemented a report in Eazy BI and the formats the report can export are not sufficient for our usecase.

The report lists jira issues and the list is grouped.

In SQL the report would be something like

SELECT textfield1, textfield2, textfield3, numberfield1, numberfield2, numberfield3 FROM table GROUP BY 1,2,3

Eazy BI can do that, but the export is not useable for our use case the xlsx export contains so many merged cells you cant work with it any more:

Unbenannt.PNG


We already contacted the vendor and they are not planning to change the export feature.

Being able to export a report to Excel and work with it there is a must-have for our client.

The Tools also offers a CSV export but you just have to do too much manual work to open it in MS Excel (pick encoding,set separtor, set decimal point, save as xlsx and so on...).

 

Is there another app that can provide this?

Or are there other reporting tools that are able to create reports about Jira Issues?

Or is there a tool that can easily convert the xlsx/CSV into something useful?

kind regards

Jens

2 answers

1 accepted

1 vote
Answer accepted

I suggest checking out Rich Filters.

Its not a BI solution but it allows to dynamically filter issues on a Jira Dashboard. The results you can then export to excel.

https://marketplace.atlassian.com/apps/1214789/rich-filters-for-jira-dashboards?hosting=server&tab=overview

Thanks, can it create grouped lists? It doesnt say anything about that in the description or the screenshots.

I didn't see the screen shot when I first replied.

There isn't a report in Rich Filters which would resemble that list. 

You can calculate values on the issues but cannot really group them together.

Another app you might look into is Better Excel Exporter for Jira https://marketplace.atlassian.com/apps/1212652/better-excel-exporter-for-jira-xlsx?hosting=server&tab=overview

If that doesn't work the best solution might be to connect directly to an external BI Solution

yeah i added it later ]:->

nifty app though, i will keep it in mind.

have a good weekend

I will also check out the Pivot Table Feature of BEEFJ, it looks promising

0 votes

The Better Excel Exporter app natively supports Excel pivot tables.

Or, even if pivot tables are hard to work with in the Excel template, it will at least export your data in a way that requires no further manual massaging. Then, you can create the pivot table in Excel with a couple of clicks.

excel-pivot-table-result

Hi,

there are about 50.000 issues created per year in the project the report is about,

will the tools be able to handle this amount of data?

kind regards

Jens

The app is driven by Excel template that have major impact on the performance of exports, obviously. Depending how the template is built and how complex it is, the load can be different.

I suggest you have a look at the performance optimization guide to build the best-performing templates.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

119 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