"JIRA Timesheet Reports and Gadgets" - unable to get desired report

I am working with the enhanced functionality from Andriy Zhdanov's Add-on named above, but am having issues getting a report that I need. I've got a trial which adds "Project Pivot" and "Worked Time Chart" to the mix along with "Timesheet".

BTW, it seems these additional features are payable directly to Andriy as far as I can tell - not sure to be honest.

BTW, I do not have Tempo, but will be considering this product to add to our cloud instance starting next year.

Anyway, "Project Pivot" is almost perfect, but I cannot get a start/stop date duration.

My goal:    Get a report given a 6 month specified duration, throw a filter at it, and return all parent issues along with summed time spent on each parent issue broken down by resource...so visually, parent issues along the 'y' and resource names along the 'x' by hour as well as a total hrs to the far right column.

Example:  I use a Filter containing the collection of issues I want to interrogate. I want a report containing only work logs between Jan 01, 2014 and Jun 30, 2014. But, I can only supply a "Number of Weeks" variable in the configuration and max is 27 weeks. It also forces me to choose either a "Role" or a "Group". Without either, no data is returned (this seems reasonable). I choose to sum subtasks which is perfect since I want summed hours spent on each parent issue occurring in the date range specified. In summary, I can't define the Jan through Jun duration I need.

1 answer

1 accepted

1 vote
Accepted answer

Hi Paul,

For the described scenario you should use Report. Please click Details link in the gadget title and you get the Report, which you can change and set specific dates. Note, you can also get to the report from Project menu - Reprots tab, see Project Pivot Report.

And this feature set is free, only Worked Time Chart requires payment.

Thank you.

Thanks, Adriy! I just discovered that the gadget itself doesn't allow you to set start/stop duration, but you are correct. When clicking "Details" to launch the full report, you can then supply these date values in its configuration. This provides exactly what I need.

It would be useful if the Excel output from a report honored the structure of the report. For example, if I opt to sum all subtasks (which rolls hours up to the parent), the Excel output exposes all of the subtasks individually so I am unable to further process the data.

Hi Paul, I think it's good point, please create request [here|https://bitbucket.org/azhdanov/jiratimesheet/issues/new], thanks!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,734 views 17 21
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you