User-centric Account summary timesheet in Tempo

I've done a lot of searching and experimentation and this appears to be impossible, but I wanted to ask here...

Is there a way to generate a timesheet that is a timesheet with a user's total hours per Account (for any of the standard time periods)?

I'm thinking of "per Account" as in the worklog attribute described here: https://tempoplugin.jira.com/wiki/display/TEMPO/Account+as+a+Worklog+Attribute

Here's what I have tried so far:

  • Use the Account view in Tempo timesheet. This gives time by account, but I'd have to pick every account individually AND remove other user's time manually.
  • Use the standard timesheet view, select the view as Report, Report in a tabular view, or Report in a table view and then under Views options select the Account checkbox. This can be exported to Excel and summed there, but that's assuming that 1) the user gets the correct report exported, 2) the user orders values correctly in Excel, and 3) the user sums values correctly in Excel. This is too many assumptions.

Is there any other way to do this?

Thanks in advance for any help.

3 answers

Hi Sean,

you could try to use the Excel export from the Account report view. Go to the Account timesheet and choose All Accounts. In the Report view you have the possibility to export the information to Excel. In Excel you will have to create a pivot table to get only the information you are interested in. See http://blog.tempoplugin.com/2012/pivoting-tempo-and-jira-reports-using-excel/ for more information.

Hope this helps

Susanne (Tempo)

Hi Susanne,

Thanks for your time and your answer. Unfortunately, given the people who will be using this, creating a pivot table in Excel (or even using Excel at all in some cases) is not going to be a viable option.

What we may end up doing is using the API to accomplish this, as we do need to do this work as much as possible within a browser.

Thanks again,

Sean

Hi Sean,

We are working towards a solution to your problem that will be available through the Tempo UI.

Best,

Viðar

This would be a great help to us as well.... +1 to this!

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Marketplace Apps

Tips on how to choose the best estimation method for your planning

Planning and grooming sessions all come with their own sets of rules. Team members meet to estimate stories or other work items, all according to an agreed-upon process. And with every session comes ...

71 views 0 11
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