Can someone maybe guide me how to achieve this?
#jirapremium #jiracloud
Hi @BenWade
As suggested by others a custom solution can help you roll up time spent at each parent level. If you would like to try out a mktplace app for your requirement, please take a look at an add-one have developed for the same use case.
The app rolls up the time spent / story points progress at each parent level. You can add it as a dashboard gadget and export the data to a csv too.
Disclaimer : I am part of the team which developed this app
Hi @BenWade
jumping in here as I see you have JXL running. What you want to do here is configure a different sum-up style. To do so, hover over the cell header, press the ⋮ (More) button, and choose "Edit sum-up style". In the dialog that follows, pick the sum up style you're looking for (I assume Sum?):
Does this work?
Please note that the Σ Time spent field is already summed up in Jira (although unfortunately in a somewhat unintuitive way), which is why the default sum up style is "None" here. We typically recommend to just use the Time spent field instead and utilise JXL's sum up capabilities.
If there are any further questions, may I ask you to reach out to us via https://support.jxl.app so that we can look into it in more detail?
Many thanks,
- Hannes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @BenWade
apologies, I feel I didn't yet fully understand what you're aiming for. Am I correct that you want to get the sum up for your Theme level (i.e., BI-602), or perhaps for all levels of your hierarchy?
If so, you can change your structure to include sum-up levels for every hierarchy level that you're interested in, like e.g. so:
With the sum-up style configured to Sum, you should now get something similar to this:
Does this look about right?
Thanks,
- H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is my custom issue hierarchy. I want to roll up hours from subtask to Theme level. Hours can be logged at any level. I need to see total logged hours for child issues under their respective themes themes. I still cannot achieve it.
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.
Hello @BenWade
Do you log time at any level other than subtask?
What event do you want to use to trigger the sum up? Does it need to be done each time work is logged, or would it be acceptable to do the sum up once a day (or on another schedule)?
Do you need to sum the information at each level, or do you just want the grand total in the Theme?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Trudy Claspill
1. time can be logged at any level.
2. sum up once a day is perfectly fine.
3. to sum up logged hpurs at each level.
I think this discussion can also be useful for you to look to help me with this automation flow.
Solved: How to use automation to sum up in EPIC the hours ... (atlassian.com)
especially this part:
This is how my hierarchy looks like:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rolling up time spent is going to be tricky when work logs can be deleted and edited, and work can be logged both in the children and the parent issues.
For another perspective on a solution (in addition to some vendors suggesting their apps) look at my and other answers on this post.
In that post I suggested using an automation that is triggered by work being logged, and executing a Log Work action to log the same amount of time against the parent issue. That doesn't accommodate work logs being changed or deleted.
Another possibility I just thought of would avoid the use of the Log Work actions and messing with deleting work logs at the parent issue level. But I haven't thought it through completely. My half-formed idea would involve using a separate custom field at each level for storying the sum of work logged one level down plus work logged at the current level. If you ran such a rule on a schedule then you could use the Lookup Issues action to collect all the descendant issues at all levels below a given issue, use a smart value to get the sum of the Time spent fields for all those issues, and then add that to the sum of Time spent for the "parent" issue and record it in the separate field. Regardless of whether work logs were deleted, added, or modified, this once a day calculation would get the sums based on all the work log info that exists for the issues.
Again, I haven't fully thought that through. I'm just brainstorming.
And there is not a native "duration" type of custom field, so the data would be a raw value that you would need to convert to minutes/hours/days/weeks/months as you deemed necessary.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Why isn't there a pre-built solution in Jira for this? Is there a valid reason for it? I need to find a way to explain to management why it's not possible to generate roll-ups from the lowest to the highest level.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have no insights into Atlassian's product design and enhancement decisions.
If they had not built the capability into the product originally, and vendors subsequently created apps that can provide the function, then Atlassian may be focussing their efforts on other enhancements that aren't covered by vendor apps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @BenWade
depending on your exact use case, you may also want to consider views that calculate these roll ups "on the fly", based on your configured hierarchy.
I was thinking that this may be possible in Advanced Roadmaps, but from a first look at it, it looks like the time spent field isn't available there. (I may be overlooking something, though.)
This being said, if you're open to solutions from the Atlassian Marketplace, there are various sum-up/roll-up apps available there. E.g., my team and I work on an app that may be a great fit for your use case, JXL for Jira.
This is how it looks in action:
(Note how the sum-up updates as we enter values at the issues.)
JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.
Any questions just let me know,
Best,
Hannes
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.