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:
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?
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.
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
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.
We’re excited to introduce external collaboration for Confluence, now available in early access. It is available to preview for Confluence Cloud Premium and Enterprise customers. (If you're not on ...
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