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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Reporting / Filtering on Subtask information

I've been tasked by my management with writing a suite of Jira reports for ticket & assignee information.

I'm using the Time in Status application with a suite of filters that I've created. One thing that I've noticed and that I am trying to figure a way around is the parent => subtask relationship with respect to actual times spent on tasks.

What the assignees are doing is reporting the Actual Effort in the subtask and leaving the parent ticket with a value of 0. The issue that this creates is that the actual effort is buried in the subtask but my reporting is grabbing the Actual Effort from the parent ticket.

So my question / challenge is how can I write a filter that exposes the actual time data in the subtasks so that it can be reported on?



2 answers

0 votes
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Nov 11, 2021

Hi @Bill Youngman 

We have built an add-on to show the sum up of time spent at each level of your issue hierarchy.

The app will show sum of time spent from sub task to story/task and to parent epic as well.

There are many other reports in the app, which will help you track your issues efficiently. Try it out.

Agile Tools - Epic Tree, Links Tree and Time in Status 

Key features of the app:

  • Links/Portfolio/Advanced Roadmaps Hierarchy :- View/Manage roll up for hierarchy (up to 10 levels deep), based on your Portfolio/Advanced Roadmaps/Issue Links parent child relationship.
  • Epic Hierarchy :- View/Manage roll up for standard Jira hierarchy. Epic -> User Story -> Subtask
  • Time in Status :- More than 7 types of Time in Status reports to track your issues.
  • Worklogs Report :- Track time spent by resources with multiple filters / category / grouping features
  • Timesheet :- View/Enter your time spent for multiple days
  • Dashboard gadgets for all the reports

Epic Hierarchy.PNG

0 votes
Julia Shcherbyna _SaaSJet_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Nov 11, 2021

Hi @Bill Youngman 

It seems you need to use pivots in Time in Status for Jira Cloud add-on. It allows creating reports based on epics and issues. You also can export this report for detailed data analysis.

pivots parent issue.png

Here is a video about How to get time data by Parents using the Pivot table? 


Try it at online demo without installing app Online Demo


It's developed by my team, so be free to ask me if you have any questions.

Hope it helps




Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events