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
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
https://marketplace.atlassian.com/apps/1220287/epictime-for-jira-sum-of-worklogs?hosting=cloud&tab=overview
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.
Hi @Prasad Kulkerni
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 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
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.
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.
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!
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.
https://community.atlassian.com/t5/Automation-articles/How-to-sum-up-logged-hours-using-automation-in-Jira-Cloud/ba-p/1409115
you can do that:issue in childIssuesOf (XX-XXXX) AND issueFunction in aggregateExpression ( Sum Time Spent, "timeSpent.sum()")
It worked great and showed the sum of hours.
Hi, in which module you use this query?
@[deleted]I used the following query on regular Jira "Search for Issues". You can see the result on screen capture
It looks like you're new here. Sign in or register to get started.
