Report with Story = X, with total of time spent on SubIssue/SubTasks = X

[Dawn E Chaplin]

I'm trying to figure out how to run a report so we can see all our Stories with the text "Time" in them so it shows all SubIssues/Subtasks on that story and total of time spent for that SubIssue/Subtask.  Something as simple as below.    Thank you.

Story      SubIssue/Task     Time Spent Total of SubIssue/Task

Time       Meetings               4 hr

Time       Reports                 2 hr

[Hannes Obweger - JXL for Jira]

Hi @Dawn E Chaplin

if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a view like e.g. this in just a couple of clicks:

This is really just one of a virtually endless number of possible views and reports; you can also view and group by any other issue fields, configure different sum-up styles, etc. etc.

Any questions just let me know,

Best,

Hannes