timespent by user? without 3rd plugins

[Angel]

Hi,

I want a dashboard with timespent by user but jql only get all time by issue.

So Is possible without plugins?

Thanks

[Trudy Claspill · Accepted solution]

Hello @Angel 

Jira does not natively offer a report of time spent per user.

If you don't want to acquire a third party app for that, you could use the Jira REST API and write your own code to extract the worklog information and parse through it to get the information per user.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-worklogs/#api-rest-api-3-issue-issueidorkey-worklog-get

Alternately you can create a JQL to search for issues where a specified user has logged time:

worklogAuthor = user

You could then export those results to a CSV or directly to Excel, and use that app to generate reports based on the data. Note the exported data would include all worklog entries for each user, not just the ones for the specified user.

[Angel]

Thanks @Trudy Claspill the problem with "worklogAuthor" is that dont seperate the timespent from difrentes users in issue.

[Trudy Claspill]

That is correct.

There is nothing you can do natively in the Jira UI, without a third party app, to get a report of time per user, or get a list of the worklogs for just one user.

Using the worklogAuthor field you could get the list of all issues against which a given user logged time.

You could export that issue data with all its worklogs.

You could use an app like Excel to work with the data to filter and summarize the worklogs for the specified user.

Getting what you want without a third party app is going to be difficult and take a lot of work. I recommend that you reconsider using an app if you need to do this reporting repeatedly.

[Madhu_RVS]

Hi @Angel 

You can use Jira Rest API's to pull this data and build on your own custom solution. I know you mentioned no 3rd party apps, but if you change your mind, do take a look at

Worklogs Time Tracking & Timesheets

You can easily view time entries for multiple issues day wise grouped by in a single view. The app allows to filter/Categorize/Group your worklogs data and a timesheet view too to track time spent by each user. And what's more it can be easily added as a dashboard gadget

[Dan -minware-]

Disclaimer: 3rd party marketplace partner

Hey @Angel - as Trudy mentions this is not natively available within Jira and arriving at the insights on your own will be difficult and time consuming.

Option 1 is to use a 3rd party time tracking service: https://marketplace.atlassian.com/search?query=time%20tracking - have engineers manually track hours for each task and make sure they label appropriately. 

Option 2 is too use a tool like minware that automatically does those calculations for you. Our time models can be retroactively applied to any of your projects, which means fully historical access to any of the example report found on our website.

We offer a free trial if you want to check it out!