Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Total time spent being logged in database for report use?

Hello

 

I am very new to JIRA and in the first sprint and am just getting to grips with everything

We are updating "Time spent" in the log work section of a sub task and keep feeding the same issue with our updates in terms of time spent

We have auto update turned on so the remaining can be adjusted

I was wondering if there was a gadget/report I can use to see the Total time spent by issue whilst we are in mid sprint?

 

Kind Regards

Helen

 

 

 

 

 

2 answers

1 vote

Hello @Helen Pippard ,

As noted by @Trudy Claspill there is not a native time tracking report that would give you an output per issue. 

Natively in Jira the time tracking details per issue is going to be located by drilling down into the respective issue view screen for a view of the issue details, Or looking at the results of an issue search within the issue navigator adding in the time spent field as a column.  To expand on this functionality and generate reports in the instance on the time tracking you would want to look into a third-party time tracking apps in the marketplace which can be seen at the link below:

Alternatively, you could look into generating custom reports using the Free Google Sheets or Excel connector apps provided by Atlassian that would allow you to sync issue data  into the external spreadsheet using the toolset of the alternate tool and render the data as desired for your reporting needs:

As an example I am using the Google sheets connector for the steps below, and you could pull individual issue worklog data using the various time tracking related fields and subfields, and I believe either timespent or Σ Time Spent (sum of time spent on the issue) would the fields you need for your report, but a list of available fields for timetracking related data would be:

  • timetracking
    • timetracking.timeSpent
    • timetracking.timeSpentSeconds
  • timespent
  • worklog
    • worklog.timespent
    • worklog.timespentseconds
  • aggregatedtimespent (Σ Time Spent)

using a query like the following to isolate to the project EXE and the current open sprint, it would populate data like shown in the screenshot beneath the query:

project = EXE and sprint in opensprints()

Screen Shot 2020-11-19 at 12.05.52 PM.png  Screen Shot 2020-11-19 at 12.06.16 PM.png

Regards,
Earl

Hello @Helen Pippard 

There is not a time report or gadget that is built into JIRA. You have to use a marketplace app for that.

Alternately you can use the Search Issue feature to find all the issues in the sprint. You can configure the display to show a List instead of Details, and add the Time Spent column to the List display. And you can use the Export Current Fields feature to export the results to a variety of format for your reporting.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

7,104 views 8 28
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you