Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Rahul_RVS_Support Marketplace Partner 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

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
Community showcase
Published in Apps & Integrations

Send an Email or Publish to Confluence - What should you do with your release notes?

Background When you hear the words ‘Release notes’, almost always you think of an unsolicited email from a software vendor. But I am here to tell you that from our data, sending release notes via E...

131 views 1 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you