How to view time per story in a given sprint (columns , rows)

[Dev]

If anyone knows: I am trying to find a way to pick a given sprint

and then see all stories assigned (one per row)

and in a column have the time that has been logged for each line item (story) be displayed with a total of all time for that sprint.

this is just for my stories.

--

how would I accomplish this?

[Dave Rosenlund _Trundl_]

Hi, @Dev.  As @Trudy Claspill points out, you will want to look to the Atlassian Marketplace for a Jira app that can help you do what you describe. @Hannes Obweger - JXL for Jira's product is a relatively new "up-and-comer" within this category.

There are also older, more established players that you may wish to consider. It's somewhat self-serving for me to say so (because I work for the company that makes Structure), but Structure for Jira and BigPicture are the ones I see most frequently when visiting ( the old days 😉 ) and/or video-meeting with Jira customers.

But, don't take our (anyone's) word for it, conduct your own Atlassian Marketplace search and check out the apps that you feel make the most sense for your situation.  Read what the vendors write about their apps, of course, but also check out the reviews from other users, and consider the number of active installation installations, whether app is Cloud Fortified, and so on.

Hope this helps,

-dave 

[Trudy Claspill]

Hello @Dev 

Welcome to the community.

Are you the only person logging time against those stories?

Do you want only the time logged during the sprint? What if you had a story carry over and had logged time against it in the previous sprint?

Jira Cloud natively provides only the simplest reporting of time for issues. Through the Search Issue screen in the List View you can get the total time logged against an issue, but you can't get just the time logged during a give date range or logged only by a particular user. To get that level of sophistication you will have to invest in a third party application.

[Rahul_RVS]

Hi @Dev 

If you are fine with a mktplace app, to get this data, you can try out our plugin

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

The app provides the following features.

Worklogs & Time tracking Report :- Track time spent by resources with multiple filters / category / grouping features. Export to csv format is also available. You can filter based on worklogs time period as well.

[Hannes Obweger - JXL for Jira]

Hi @Dev

welcome to the community!

If I understand your requirements correctly (and assuming that you're open to solutions from the Atlassian Marketplace) you may like JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows grouping and summing up your issues by any issue field, plus provides very powerful column sorting and filtering capabilities (as you may know from Excel or Google Sheets). This enables you to build a wide range of (real-time) reports, including, I believe, the view that you are looking for.

This is how this could look in action:

Note that you can view (and inline-edit) any issue field, model almost any issue structure, and use different sum-up techniques, so this is really just one example. More info at https://jxl.app. Disclaimer: I work on JXL :))

Hope this helps,

Best,

Hannes