Reports And Exported Excels are Different.

Question

Hi,

I am a newbie of JIRA Core. I input real data in my account, than I want to checkout reports. When I created a filtered and grouped custom report from Project Pivot Report section, and exported it as Excel, it does not contain the same content with the web page does. Excel really has no group or filtered. Is it something I do wrong, or something to still process by Atlassian?

By the way, my report on the web page which is grouped and filtered is something for grouping subtasks according to parent issues and summing the subtask times in a certein time period.

If anyone can help I will be appriciated. Thank you for your time...

Midori · Answer

You can define a custom template for the Better Excel Plugin, to bring your data into multi-dimensional Excel pivot tables (and pivot charts like the one below):

jira-pivot-chart.png

There is no built-in JIRA feature for this, and in fact, the built-in Excel export is rather limited.

jira-pivot-chart.png

Ignacio Pulgar · Answer

The addon's name is JIRA Timesheet Report and Gadgets, and can be found here: https://<your-company>.atlassian.net/plugins/servlet/upm#manage/jira-timesheet-plugin
Both gadgets are available for free, but there are some other features that require you to buy a license.
We use this addon (free version), but had to enable it manually, as it wasn't enabled out of the box.

Nic Brough -Adaptavist- · Answer

Nope, it's not.  Core doesn't have a project pivot report.  I suspect you're using an add-on, but I can't be sure which one, because there's a number that mention pivot reports.

Do you mean the Timesheet one that @Ignacio Pulgar suggests?