Total Time Spent by user and by organization
10 answers
Welcome to the community !!
As suggested by everyone a mktplace app can help here. If you are open to try out one pls take a look at
Worklogs Time Tracking in Jira & Timesheets
With this add-on, you can easily -
- Create user wise time reports in real time by grouping & categorizing data with aggregation
- Prepare your reports based on Project/Sprint/Issue Type/Assignees/Authors and various other filters
- Group your data to build more meaningful reports
- Enter Time Spent for multiple issues from Time sheet screen. With Calendar view and Board view
- CSV Export
- Dashboard gadget
- Add and use custom attributes to worklogs (like organization, billable status, work type, cost center, etc.) and create reports based on those attributes.
Disclaimer : I am part of the dev team
Hi @Rafael Marin,
Welcome to the Atlassian Community !
Jira’s built-in dashboards are enough for basic reporting, but when you need more detailed worklog analysis and better time tracking for managers, third-party apps can be very helpful. WorklogPRO is a tool built for these needs and provides advanced reports, timesheets, and dashboards.
📊 For the first need, WorklogPRO shows how much time each user has logged in a selected time period (like last week, last month, a sprint, or custom dates). This information can be shown in charts, dashboards, and timesheets, so managers can easily see team activity.
👥 For the second need, you can group logged time by team, project, or organization. This helps managers understand how time is used across the team or company.
📋 WorklogPRO also lets you add Jira fields like Total Time Spent, Original Estimate, and Remaining Estimate into timesheets. This makes it easier to compare planned work vs actual work in one place.
Other features include:
- 📈 Time tracking by user, issue, and project
- 📆 Reports for weekly, monthly, sprint, or custom dates
- 📊 Custom dashboards and charts
- 📤 Export to Excel or CSV
- 🔐 Permission-based access for managers and team leads
- 💰 Cost and billable time report
🍀 To learn more, feel free to contact me or explore the application through the Atlassian Marketplace link I’ve provided. 🍀
Disclaimer:I work for the vendor who developed this application.
Welcome to the community, @Rafael Marin.
As mentioned by others, many Marketplace apps should be able to calculate this for you, including our app Quick Filters for Jira Dashboards (I’m part of the team behind it).
That’s why I’m a bit surprised to hear it didn’t work as expected in your case. I’d recommend reaching out to the Marketplace partner directly to better understand why the gadgets aren’t displaying the data the way you need.
Quick Filters for Jira Dashboards can also build statistics for any numeric field, including “time invested”, as long as it is configured as a number field.
On top of that, the app is very easy to set up and maintain, since all configuration is done directly on the dashboard rather than in a separate admin menu.
Hey @Rafael Marin
First, welcome to the Community!
When tracking "time invested," it is important to first distinguish between manually entered worklogs (timesheets) and the actual elapsed time an issue spends assigned to a person or entity.
If you are looking to track the actual elapsed duration rather than manual timesheets, native Jira dashboards do not have out-of-the-box gadgets to calculate this accurately.
If you are open to using a Marketplace app, you can easily build this exact view using Timepiece - Time in Status for Jira.
Here is how you can achieve your goals using just two Timepiece gadgets on a single Jira dashboard:
Total time per user: You can use the Assignee Duration report. This report automatically calculates and displays exactly how much time issues spent assigned to each specific user during your selected time period (e.g., one week or one month).
Total time per organization: You can use the Any Field Duration report. By selecting "Organization" as your history field, the report will calculate the total time spent on issues broken down by each organization.
You can add both of these reports directly to your Jira Dashboard as interactive gadgets and visualize them using bar or column charts for a quick executive view.
To learn more, you can find Timepiece - Time in Status for Jira on the Atlassian Marketplace.
Full disclosure, I'm on the team that makes Timepiece. Hope this helps you get the exact dashboard visibility your manager needs!
As representative of Actonic Products, I may say that of 3rd party apps, Report Builder's https://marketplace.atlassian.com/apps/1216997/report-builder-custom-charts-time-in-status-for-jira Universal Visual Builder is exactly the right feature for this, and it's the "visual builder" you're referring to (Actonic also has a "Scripted Report" expert mode that uses HTML/JS, but you won't need that here).
For total time per user (e.g. last week), you will need:
- Go to Apps → Report Builder → Create Report → Universal Visual Builder (or select the predefined Timesheet template).
- Scope: filter by the relevant project(s), spaces, or a JQL query.
- Time period: set the worklog start date range to the last week (or use a relative period like "Last 7 days" / "Last Week" so it stays current automatically).
- For output format: choose some chart: Pivot Table or Bar chart.
- Calculation: set the aggregation to sum of time spent (logged time), and set the grouping dimension to Worklog author. Group options sum the time and show the total spent, so each user collapses into one row/bar with their total.
See the example below with ready report
For total time per organization you will just need to aggregate by the organisation field you have defined in your Jira, the rest stays the same.
Both kind of reports you may share directly as links to your management, or configure as gadgets on a standard Jira Dashboard.
Regards,
Rustem
Hey @Rafael Marin! 👋
Native Jira dashboards struggle with this kind of aggregated time reporting — that's why your attempts probably came back with wrong or incomplete totals.
JetTime (a third-party Jira app) does this through saved reports rather than dashboards. You can build a report showing total time per user over a period (e.g., last week), and another broken down by JSM organization. Save the report setup once and reuse it whenever the manager needs an update, plus export to Excel or PDF.
JetTime features:
- Time reports with break-down by user, project, JSM organization, or any other field
- Saved report templates you can reuse
- Time tracking & timesheets with improved Log Work UI and timers
- Cost tracking with custom financial fields
- Custom metrics (mileage, materials, activity types, etc.)
- Reports with PDF & Excel export
- Runs fully on Atlassian infrastructure, so data stays inside Atlassian Cloud
👉 JetTime on the Atlassian Marketplace
— Anton, JetTime founder
Hi @Rafael Marin,
Welcome to the Atlassian Community.
Unfortunately Jira does not provide any out-of-the-box gadgets or reports that support this type of statistics. To obtain this functionality, you would need to look for a suitable app or plugin on the Atlassian Marketplace.
If you want to try an app I would recommend the Worklog Reports & Timesheets gadget available in the Advanced Edition of our Great Gadgets plugin.
With this gadget you can easily obtain these stats and display the result as a table, heatmap table or charts of various types on your Jira dashboards.
To obtain this the gadget shall be configured like this:
If you prefer a chart, just change from Table to the desired chart type.
Similar to this you can get the statistic by Organization (just use Organizations field instead of Worklog Author).
The gadget is higly configurable. You can get them both in the same gadget, with total time spent grouped weekly or monthly, as in this example:.
Hope this helps.
Danut,
Hello @Rafael Marin,
As already noted, Jira's native time tracking reports at the issue level, so it won't roll totals up by organization or by user for you.
If you're open to an app from the Atlassian Marketplace, JXL for Jira is a spreadsheet/table view for Jira that handles the organization report directly. You point a sheet at your JSM issues, group by the Organizations field, and add a sum-up on the Time Spent column. Each organization then shows its total logged time, and you control which issues are included via JQL.
Two honest caveats so you can judge the fit:
- JXL sums the issue's total Time Spent field, so the numbers reflect all time logged on those issues, not only worklogs inside a specific week. A strict per-week window isn't something it filters at the worklog level.
- It can't yet attribute time to the individual worklog author (a known request we're tracking). You can group by Assignee and sum Time Spent, which works if the assignee is the one logging the time, but it won't split a shared issue across multiple loggers.
So it's a strong fit for the per-organization roll-up, and a partial fit for the per-user one.
Disclosure: I'm on the JXL team.
Best, Paul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.