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

This widget could not be displayed.

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

This widget could not be displayed.

Hi Sean,

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

Best,

Viðar

This widget could not be displayed.

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

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in Teamwork

What teamwork quotes inspire you?

Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork?  We've compiled a list here, along with...

190 views 18 7
Join discussion

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