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

Question

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?

Rahul_RVS · Answer

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.

Dave Rosenlund (Trundl) · Answer

Hi, @Dev.  As @Trudy P 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

Hannes Obweger - JXL for Jira · Answer

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