Report on Time spent by every user with out any addon

[Mahanth Prudhvi P]

Hi,

I have a requirement where I want to track the every user "Time Spent" on every issue. JIra actually has a workload pie chart widget but that doesn't work when multiple users work on same issue.. Because that widget shows the complete time spent recorded on the issue but i want to divide it on user basis.

Is there any option for this ,other than using addon?

Thanks & Regards,

Mahanth Prudhvi P

[Trudy Claspill · Accepted solution]

Hello @Mahanth Prudhvi P 

Without an add-on the only option is for you to use the Jira API to extract the worklog information and manipulate the data outside of Jira to generate the report that you want.

[Mahanth Prudhvi P]

@Trudy Claspill Thank you

[Mary from Planyway · Accepted solution]

Hi @Mahanth Prudhvi P 

Tracking the time each user spends on every issue in Jira is a common requirement, especially in collaborative environments. While Jira's built-in workload pie chart widget provides a visual representation of time spent on issues, it doesn't break down the time by individual users when multiple users work on the same issue.

To achieve this without using an add-on, you can utilize Jira's built-in features combined with some manual steps:

Using Jira's Built-in Features

1. Work Log Report:

   • Jira allows you to view detailed work logs for each issue.
   • Go to the specific issue, and under the "Activity" section, there is a "Work Log" tab.
   • Here, you can see the time logged by each user.

2. Filters and JQL (Jira Query Language):

   • You can create custom filters using JQL to get a list of work logs per user.
   • Example JQL query: worklogAuthor = currentUser() AND worklogDate >= startOfWeek()
   • This query will return all issues where the current user has logged time within the current week.

3. Exporting Data:

   • Export the work log data to a CSV file and use Excel or any other spreadsheet software to analyze and visualize the data.
   • This method requires manual effort but allows you to manipulate the data as needed.

Planyway as an Alternative Solution

If you are open to using an add-on, Planyway is highly recommended. Planyway is a powerful tool for time tracking, resource management, and visualization in Jira. Here are some of its benefits:

• Detailed Time Tracking: Planyway allows you to track time spent by each user on every issue with detailed breakdowns.
• Resource Management: It helps in managing workload distribution among team members efficiently.
• Visual Timeline: Provides a visual timeline that helps in understanding who is working on what and when.

[Mahanth Prudhvi P]

@Mary from Planyway Thank you.

I can use option 2 & 3.

[Hannes Obweger - JXL for Jira]

Hi @Mahanth Prudhvi P

I understand that you prefer solving this without an add-on. If an add-on should become an option for you in the future, I think you'll like the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called history columns that aren’t natively available, including time with [assignee], time in [status] with [assignee], and many, many more.

This is how it looks in action:

As you can see above, you can easily sort and filter by your history columns. You can also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Amay Purohit_RVS]

Hi @Mahanth Prudhvi P 

You can use Jira Rest API's to pull this data and build on your custom solution. I know you mentioned without add-on, but if would still like to try one take a look at

Worklogs Time Tracking & Timesheets

You can easily view time entries for multiple issues day wise grouped by assignees in a single view. The app allows to filter/Categorize/Group By your worklogs data and a timesheet view too to track individual time spent. 

Disclaimer : I work for the vendor who built this app

[Mahanth Prudhvi P]

@Amay Purohit_RVS Thanks for suggesting this addon.

We were already using an addon for this but we don't have it's necessity up to the mark. So we have cancelled the license, we rarely use it. That's the reason I don't wanna go for an addon.