Total Time Spent by user and by organization

[Rafael Marin]

I want to create two dashboards to show it to the manager.

The first is the one that shows the total time invested by each user during a specific period (for example, over the last week).

The second is the one that shows the total time invested in each organization.

It seems like these dashboards should be native to Jira, but everything I've tried has failed to achieve these goals. I even tried several Jira apps, but none of them were able to display the correct amount of time spent.

Is there a free Jira app that can fulfill these requirements? If this functionality is available natively, what type of dashboard should I use, and how can I configure it?

[Trudy Claspill]

Hello @Rafael Marin 

Welcome to the Atlassian community 

Are your users using the native Log Work function to log time against work items?

If not, how do they record in Jira their time spent doing work?

Jira natively supports users recording time spent on work items. They can specify the date the time was worked and the duration. The can make multiple such entries per work item.

Jira does not natively provide ways to report the time logged per user. It supports only reporting total time logged against work items. It also does not support specifying a date range to apply against the date the time was worked.

To get features like that will require an app either from the marketplace or one you develop yourself.

Here is a sample search for such apps from the marketplace. https://marketplace.atlassian.com/search?query=time%20tracking%20reporting%20jira

You will need to review them or adjust the search to find the ones that are free.

[Paul Glantschnig _Appfire_]

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

[Konstantin Kireev]

Hi @Rafael Marin

Handling time-spent aggregations across organizations is a common challenge in JSM because Jira's native reporting is primarily focused on the issue level, not the organizational resource level.

If you are open to using a specialized tool for these dashboards, Resource Management for Jira app is a perfect match for your first requirement. It allows you to see exactly what each user has reported over any given period of time in a clear, professional view.

Regarding your second goal (Total time by organization):
If your workflow involves using specific work items (tickets) for each organization, our tool would cover this requirement as well.

However, if you need to aggregate time across all work items related to an organization (regardless of the specific ticket structure), that typically requires a more customized aggregation engine. If you find that our current timesheet views fit your general purpose but you need that specific 'Organization-wide' roll-up, we'd be happy to discuss your requirements. We are always looking to expand our feature set based on real enterprise needs and could potentially build a specific solution for this and release it on the Marketplace.

I'd be glad to jump on a quick call to see your current setup and figure out the most efficient way to get you these reports.


Kind regards,
C