How do I see in the Filter Results in Dashboard the Time Spent details for each story for Epics?

Question

See query below screen shots....

How do I see in the Filter Results in Dashboard the Time Spent details for each story for specific Epics where some of the Stories have subtasks?

I see just the Story name, no Time spent, see screenshot abovr.

I have enabled Time tracking in the tickets and in the Story ticket I have the 'Include child issues' ticked so the time aggregates in the parent Story ticket.

In my JQL I have been able to include subtasks so the Time Spent displays the time taken but only per subtask, I want to see in my dashboard the time in total for the Stories.

My JQL reads:

project = "Engineering" AND (

"parent" = "KE-8690" OR parent in ("KE-8691", "KE-8692", "KE-8693", "KE-8694", "KE-8695", "KE-8696", "KE-8697", "KE-8698", "KE-8699", "KE-8700", "KE-8701", "KE-8702", "KE-8703", "KE-8704", "KE-8705", "KE-8706", "KE-8707")

) AND labels in ("DocRev", "DocAcq", "Playbook", "Release_notes")

Dmitry Astapkovich _Colined_ · Answer

@Tanja Clarke , you can try adding summation column:

It will show aggregated value from sub-task under Stories.

Madhu_RVS · Answer

Hi @Tanja Clarke ,

Welcome to the community !!

If you would be interested to try out a mktplace app for this requirement, do take a look at

Issue Hierarchy

The app shows a complete hierarchy of your issues with time spent at each level and roll up at each parent level, and with clear timeline view. Below are the main features of the app.

- Sum up values to see overall progress for your Issue Hierarchy

- View the full hierarchy of linked issues (upto 10 levels), Portfolio/Advanced Roadmaps, Epics, and Subtasks

- Apply filters to put the focus on the relevant data only

- Excel like editing for all the values right on the report and see real time progress updates

- Export to a CSV file

- Embedded Epic Hierarchy on Issue Screen

- Dashboard Gadgets

- Gantt View

- Dark Theme Support

(Disclaimer: I work for RVS, the vendor for this app)

Atlass Monster · Answer

The free gadgets are limited to some features. You can trying to pull the data in other ways. Like using a custom field and automation to update the data and place it in the parent issue, then with JQL and a view of the custom field you can see that data.

Another way is to export the data and parse it in Excel or PowerBi.

In our team we use app for many Time Sum, original author time, Sprint calculation and much more. I can share the name of the app if you need something more powerful and on the budget.