Community
Products
Jira Software
Questions
How can I generate a report of time logged per person and not per task?

How can I generate a report of time logged per person and not per task?

I've been looking through the forums and have found similar questions, but not quite the exact thing I'm looking for. So I apologize in advance if this question has already been answered and I missed the post (I hate creating duplicates).

I've been playing around with the built-in reports in JIRA, in particular the Workload Pie Chart report. I wanted to see if I could get a report of how many hours an individual in a project has logged across all the tasks he has logged work in. What I found was disappointing.

I made a single test ticket in a brand new fix version (so it was the only ticket available in my query) and assigned it to myself (person A), and logged 5 hours on the task. I then assigned the ticket to a co-worker (person B), and he logged 10 hours on the task. When I ran the workload report by assignee and on time spent, the only person that appeared in the report was person B with a total log time of 15 hours (his hours plus my hours). What I was hoping I would get was person A having 5 hours and person B having 10 hours.

The problem is, person B was the last assignee for the task. And the task currently had 15 hours logged on it. So, the report says that person B has 15 hours logged. The report does not go into the task and extract the hours per individual -- just the total hours on the task and the last person assigned.

So, I think you know my question. How can I generate a time logged report per person regardless of if the task they were involved in was also worked on by other individuals?

Like like this

257627 views

Atlassian recommended

Hi everyone,

In the interest of brevity, I’ll mention that there are many resourceful solutions using scripts scattered around the thread. If you have time and are interested in scripted solutions, please have a look at some of the options provided by other clever Jira users.

Jira’s built-in time tracking offers what we believe is the necessary featureset for the vast majority of teams. While this may not address the entire set of features your team may want, we believe the core product addresses the needs of most teams while offering the ecosystem the ability to extend Jira. Many marketplace apps exist - both free and paid - that add a range of features to time tracking. I encourage you to take a look at the options to consider what most fits your team’s needs:

The apps range from simple (simply changing how time is entered) to complex full-featured reporting solutions.

Cheers,
Daniel | Atlassian Support

15 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

74 votes

Answer accepted

I think you may be missing the point of people's frustration. JIRA has this built-in reporting feature. However, the feature doesn't really do what it's supposed to do. Yes, this can be fixed with some third-party add-on. However, I think the expectation is, if you've made it part of the main JIRA package already then it should work as expected. Either Atlassian should fix what is there, or take it out entirely so users know to use a third-party. Not leave a broken feature in and answer inquiries as to why it doesn't work with "use someone else's plugin." I believe the frustration is warranted.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I keep getting updates on this issue in my email, so I figured I'd put this answer in at the top so people don't need to look further. The answer is no you can't generate a per-person report for a single ticket using the built-in report generator. Use a third-party plug-in. The built-in JIRA reporting does not work as expected.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

I have a python script that uses the JIRA rest api to list all the work items reported per person, per sprint, in the form of CSV. Then you can open it in a spreadsheet and use pivots etc to look at the data however you want to. I wrote it at work so can't just post it, but I can tell you how I did it

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

I wrote a small PHP app to do this, you'll need to host it somewhere but it should help / be a starting point for your developers to add to,

Can be found on github here:

https://github.com/fyllepo/jira-report-time-logged-by-user

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

Hi Roger,

a python script would be my prefered solution.

Can you please explain, how you implemented it or share the code?

Thanks,

Daniel

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Yana encheva likes this

Thank you Philip Elliott

I'll be looking into your PHP app soon.

In your README you write

"Run

composer install

to install PHP dependencies." Run from where? In what consol?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hey Erik,

Apologies for lack of docs, composer is a bit second nature at the moment to me.

If you visit the composer get started guide and run the command from command terminal after you've gone through it.

https://getcomposer.org/doc/00-intro.md

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • sajal.goel likes this

For fans of .NET I took Philip's code and created a LINQPad script. I'm assuming a Windows OS. For *nix environments it wouldn't be hard to convert this to a Groovy script.

https://www.linqpad.net

Code is here:

https://gist.github.com/Tempest1000/bcfe53eda7c0b6dadda95acb39cf46e7

It doesn't include the filtering or export to CSV capability, it just generates an HTML file using Philip's HTML and drops it here:

%userprofile%\AppData\Local\LINQPad

It will run out of the box with LINQPad, but it does require one additional assembly:

Newtonsoft.Json

That can be downloaded here:

https://www.newtonsoft.com/json

Then in LINQPad with the script open:

F4 > browse > choose Newtonsoft.Json.dll

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

78 votes

Oh god, wow..everything that should be simple is made so unimaginably complex in Jira. I log my work on everything and now I just want a simple report on what I worked on and there is no handson report builder giving simple meaning to the data i log every day...This system just keeps leaving me so frustrated. It makes no sense what so ever. Why would i be able to log my work if I cant track it? It blows my mind.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Amen. Why is JIRA like this?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

I completely agree... the model has been engineered to have to rely on other complex useless plugin's for which you need to pay additional monthly subscriptions.. JIRA ITSELF SHOULD HAVE THE DECENT REPORTING ENGINE... useless..

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

Completely agree! Useless!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • gaurav.arya likes this

If there's a report generator built-in, it should work properly. We should not have to rely on third-parties to get basic functionality. To me, this simply looks like a case of lazy programming.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

There's probably a paid plugin for that?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

There is a free plugin called Timetracker which adds the functionality.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Where do I get this timetracker?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I suppose Daniel mentioned this: https://marketplace.atlassian.com/plugins/org.everit.jira.timetracker.plugin/server/overview

Unfortunately it does not work with JIRA in cloud.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Agreeed - the whole point of buying software is not having to program your own solution.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

9 votes

Hi Edward,

As an alternative you may use Confluence and SQL plugin to query directly JIRA database.

This is an example of usage with a query that will return all work logged per user in the current day with the result in minutes:

{chart:title=Time Logged in Minutes|type=pie|dataOrientation=vertical}
{sql:output=wiki|dataSource=JIRA}
select author, concat(sum(timeworked)/60,' Min') as "Time Logged in Minutes" from worklog where updated like concat(curdate(),' ','%') group by author;
{sql}
{chart}

Cheers

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

The key point that kills this is having to buy a whole separate product to run a report.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

Exactly... why would I want to purchase another product to generate the report? JIRA should do this..

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • gaurav.arya likes this

Why should JIRA do everything and cover every use case? How complex and expensive would it be then?

Simply go to marketplace and extend its functionality with a plugin. It is a perfect solution for everybody because you don't need to pay for other redundant functionality you don't need.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

knowing what's been worked on by whom for how long doesn't seem like an edge use case. even if JIRA doesn't want to include this type of report, the information is clearly already available in the backend ... all we're asking for is the ability to write reports against the information already collected by and avaialble in the system without having to jump through hoops or spend a lot of money on top of what's already been spent just to buy the product itself.

It's like using Word to create a document, and then needing a third-party plug-in to print it.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • like this

You already have ability to prepare such report using Java and P2 plugin SDK or even SQL directly.

JIRA is not a timetracking system hence it is not a daily use case.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • John Chesshir likes this

It sounds like you're saying we need a programmer on-hand to support JIRA reporting. Is that what you intended to convey?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

You either need a programmer or buy an add-on. It does not make sense to expect JIRA do everything. There are various groups of users and each group needs different features. Adding all those features would turn JIRA into not usable monster.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Darius Mihai likes this

^ that ^

thank you, Edward, so much that.

I'm used to having user-friendly front-ends to create reports for systems with database back-ends, so to me, the feature is having this friendly front-end, not the specific reports themselves. Because yes, Gebsun, trying to figure out all the reports anyone could possibly want would be quite messy! Which appears to be the direction JIRA chose ... have super-easy "widgets" available for each specific need rather than a flexible front-end to meet a variety of needs without the need for elevated permissions or expansive technical knowledge.

We have the data center version, which it seems most plug-ins don't support, and we don't have the ability to dedicate a programmer to giving JIRA the functionality most of our users think "should" already be part of the platform.

The rampant requirements that those supporting "basic, must-have functionality" have a programming background and/or elevated permissions may be the death knell for JIRA in our environment.

I'd really rather not go back to the stringent TFS environment, but if we have to then we have to.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

List of top voted JIRA issues and requirements: https://jira.atlassian.com/browse/JRA-3821?jql=project%20%3D%20JRA%20AND%20resolution%20%3D%20Unresolved%20ORDER%20BY%20votes%20DESC%2C%20priority%20DESC

There are so many items more important than "Time report per person" that it is not justified to say that "most of the users" need the report. We should rather say that "some of the users" need the report and therefore understand why Atlassian prefers to focus on other problems.

At the same time we should enjoy that the problem can be quickly addressed with third-party add-on.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • John Chesshir likes this

When comes to Data Center, it is indeed a problem. Many vendors don't want to invest their time and make the add-ons compatible.

On the other hand it is (I think) possible to install not compatible add-on and it might work fine. The rule of thumb is that add-ons reading data (e.g. generating time reports) should work fine.

The problem with Data Center is that writing data needs additional care (synchronization between DC nodes) and that introduces additional complexity.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

6 votes

Edward -

Have you installed any of the timesheet plugins?

https://marketplace.atlassian.com/search?q=timesheets

These two are pretty rich and well supported -

https://marketplace.atlassian.com/search?q=minyaa

https://marketplace.atlassian.com/plugins/is.origo.jira.tempo-plugin

If you want a specific report (beyond what is in their canned solution), I am sure they can do it for you. Reach out to them direct..

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

5 votes

Mind-blowing, indeed. I'm looking for the same thing. It borders on the hostile to give us a way to log time, but not to be able to query/report on such a simple thing. (As Linus said: "Would you give a starving dog a rubber bone?") What are these people thinking? Any chance we'll see this capability in the future?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

2 votes

Edit 1/24/2017: The plugin I was using "JIRA Timesheet Reports" in my response below was removed from the cloud may 2016 and I moved to AIO reports.

Hi, I am new to JIRA and encountered the same thing. Here is my current progress.

I have enabled time tracking in JIRA
Now under the "issues" button, I can see "Time Sheet subscriptions". click it.
Select the "Pivot Report".
Next, click the "configure" button or "Change" button to configure the report.
1. Choose your start and end dates
2. Select "Any Group"
3. Uncheck "show details"
4. Check "sum subtasks"
5. Check "Collapse Field Groups"
6. Click "Next"
The report now shows time per user, and time by project. You can choose to email, open in Excel, subscribe, etc. Gave me exactly what I wanted, a little more actually, but was too much clicking. I'll keep my eye out, there has to be a simpler way to do this. I am currently evaluating Tempo timesheets as well.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Is this JIRA for cloud product? I do not see any of these options at all...

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

How Can I have ot per period ( weekly ) time spent per person per issues

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I cannot see "Time Sheet subscriptions" under issues. Please can you provide some more clarity on this.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

sorry for the delay in response....my implementation is in the cloud and as of May 2016 they removed the JIRA timesheets and gadgets, so this is no longer available. I am now using Tempo timesheets along with AIO reports. Thanks

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

2 votes

Please take a look at eazyBI report creation plugin for JIRA. With eazyBI you can create custom reports based on JIRA data.

Here is an example report of hours logged by user per issue. You can also change the report by adding Project dimension from Pages to rows and remove the Issue dimension to see hours logged by user for Project.

Let me know if you have any additional questions about eazyBI. You can also contact me directly at support@eazybi.com

Kind regards,
Lauma

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

EasyBI really does seem to have a lot of potential, but it is also a LOT of money, and so far, I'm failing to see the "easy" in its use. Setting up reports looks very difficult. Am I missing something?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Robert,

Thank you for considering eazyBI for your reporting needs!
To assist you with getting started, please take a look at some videos in our documentation - Getting started, data model for JIRA as well as issues import.

There are simple and quite advanced possibilities to eazyBI (see calculated members). Nevertheless, eazyBI support is ready to assist you with getting started so let us know if you have problems with some report creation to support@eazybi.com.

Kind regards,
Lauma

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I get this error when trying to import from Jira:
NoMethodError: undefined method `atlassian_plugin' for nil:NilClass

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Zac,

I am sorry for the troubles this is causing to you!
Please send eazybi-queues.log file from JIRA Home / log directory as well as what version of eazyBI you have currently installed to support@eazybi.com so we can analyze what is the cause of the error and resolve it.

Kind regards,
Lauma

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hey, Lauma.

My issue has been resolved. I believe eazyBI report creation plugin for JIRA meets a business need. We are currently reviewing the benefit-cost ratio.

Thank you for your help and communication on the matter.

Regards, Zac.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

2 votes

Jira timesheet report works only for time-frames no longer than two months... And you need to run the report with all those parameters where the simple stats at the dashboard is needed.

I have the same goal as the topic's author described. We just need a simple chart that shows how many hours each person in the system logged for project during all its time. The Pie Chart widget is pretty much what we need, but it has this ridiculous issue that the time logged per task is attached to the current assignee or reported, but not the user who actually logged the time.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

1 vote

We're creeping up on July here, guys. Nobody at Atlassian has any solutions to offer?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Atlassian recommended

Hi everyone,

The apps range from simple (simply changing how time is entered) to complex full-featured reporting solutions.

Cheers,
Daniel | Atlassian Support

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

I use this add on , well worth the money

JIRA Timesheet Reports and Gadgets Plugin - Andriy Zhdanov

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Tempo Time sheets. We dont use it but users wanted it. Its not really focusing on anything related to the scrum/agile process, which is why I think Atlassian doenst provide it.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hey,
we released "xPort - Custom Worklog Export for JIRA" for JIRA 7+ on the Atlassian Marketplace including the following functions:

Create individual templates using your own corporate identity with optional project information, formats and your own images

Export worklogs & JIRA project information instantly

Generate automated performance records for your employees

Send reports automatically via email (in predefined time frames)

Please click here for more information: https://marketplace.atlassian.com/plugins/com.decadis.jira.xport/server/overview or contact us directly via email to atlassian-marketplace(at)decadis(dot)de

With best regards

Nicolas Werle
(Decadis AG)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks Nicolas,

Everything we needed to provide proper time spent by author was here. Thank you

I have added https://marketplace.atlassian.com/plugins/Gallifrey/cloud/overview to assist with the entry of the worklogged.

between these 2 apps i now have it all.

Great stuff

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

You can also do it with WorkLogPRO for JIRA add-on. In addition to grouping by user you can also group on other attributes such as sprint, project, epic etc. You can also add these charts and timesheet reports to dashboard.

WorklogProCharts.png

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

You have to write custom gadget for this task or use some public plugins, for example https://marketplace.atlassian.com/plugins/jira-timesheet-plugin

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

Was this helpful?

Thanks!

Jira Software

Products

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Get product advice from experts

Join a community group

Advance your career with learning paths

Earn badges and rewards

Connect and share ideas at events

How can I generate a report of time logged per person and not per task?

15 answers

1 accepted

Comments for this post are closed

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events

Ask a question

Products

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Get product advice from experts

Join a community group

Advance your career with learning paths

Earn badges and rewards

Connect and share ideas at events

How can I generate a report of time logged per person and not per task?

15 answers

1 accepted

Comments for this post are closed

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events