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

Reports And Exported Excels are Different.

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

4 answers

0 votes
Nic Brough [Adaptavist] Community Leader Jan 04, 2016

You'll need to explain the "project pivot report" bit.  What is the filter behind that, and what does it return?  Then, what do we see in excel?

0 votes

Well, "Project Pivot Report" is one of standart reporting type of the JIRA Core. It returns something like who spend how many times for which issue/sub-task, and when did s/he spend these time in week or month.

It has also some filtering and grouping options. I do want to group sub task according to the parent issue and filtering them for spesific time range. It is successfully done for web interface but when I click the Export Excel option, It dumps excel with no grouping options. Excel contains ungroup time schedule.

I am not sure if it is clear now. I can also add some screenshots if it is still ambiguous.

Nic Brough [Adaptavist] Community Leader Jan 05, 2016

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?

Ignacio Pulgar Martín Community Leader Jan 05, 2016

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.

0 votes
Ignacio Pulgar Martín Community Leader Jan 04, 2016

There's a specific label for tagging issues related to said plugin.

You can find all available documentation here: http://www.jiratimesheet.com/wiki/Overview.html

If you don't find the answer there, send an email to the developer: azhdanov@gmail.com

0 votes
Ferenc Kiss [Midori] Apr 01, 2016

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.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

683 views 7 0
Join discussion

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