You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
We have Tasks under an Epic and time is tracking at Tasks level. At Epic level how can I get sum of time spent on Tasks level
you can do that:
issue in childIssuesOf (XX-XXXX) AND issueFunction in aggregateExpression ( Sum Time Spent, "timeSpent.sum()")
Hi @Prasad Kulkerni - not sure if you ever got this solved or not. But here is an article that should help walk you through a solution using Automation for Jira.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As mentioned above there are number of apps which can do this.
Our app Agile Docs can do this for you in a couple of way.
You can view a report of the rolled up time logged for each Epic directly in the app while seeing the time logged against your entire hierarchy.
You can also set the total time logged to display directly inside your Epics.
Hope that helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please have a look at BigPicture/BigGantt. It seems to be a good match! The plugin displays and aggregates data not only on a single task & epic level but also on a project or its phases level. The plugin gives you the possibility to aggregate data of statuses, progress, and time tracking.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Prasad Kulkerni ,
It is not possible out-of-the-box in JQL. You can calculate it by coding which parses issue history rest api json for each issue. Or you can search for marketplace apps which does the same for you.
As an alternative, you can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count.
Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports(eg. average in progress time per project). And all these are available as gadgets on the dashboard too.
Here is the online demo link, you can see it in action and try.
If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You may want to try out our plugin, Agile Tools : Epic Tree & Time in Status
The app provides roll up for time estimates fields for an Epic in a hierarchy.
It provides 3 major functionalities in one add-on
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As an option, you can try Time in Status for Jira Cloud add-on (developed by my team). For more information please read here:
How to get time in status data by Epics?
Hope you find the best solution for you.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Prasad Kulkerni
Welcome to the community.
Summing up time spent to a parent epic is not a built in feature for JIRA Cloud.
You could look at using an app to get that information separately. For instance we use Worklogs - Time Tracking and Reporting
With that tool we use filters to collect all the time tracking information and then create a Worklogs dashboard that summarizes the information by epic.
There are other apps that can provide sum up functionality too, like this one
I've never used that one so I can't say how well it works. And I'm sure there are others.
I am sure that you could also create a custom solution where you define a custom number field in the Epic and then maybe use Automation to update that field each time somebody logs time against a child issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.