Hey there,
I have set up a quite “easy” chart to display on high level the efforts spent on different types of tasks (new features, technical refactorings, bug fixes). I know just realized by accident that the numbers I am collecting are not correct.
Here is the chart I am using
The efforts are tracked on sub tasks and I was expecting that the following measure would sum up all reported hours on either the parent task or any of the sub tasks.
[Measures].[Hours spent] +
[Measures].[Sub-tasks hours spent]
It seems that currently only the hours on all parent issues are displayed. The hours reported on sub tasks are neglected. I could see by checking a couple of example issue in Jira itself.
Can anybody help to find a solution here?
Kind regards
Daniel
Hi @Daniel_Sander,
The predefined measure “Hours spent with sub-tasks” shows aggregate results of parent and subtask logged hours, and those data are grouped by parent issue fields like Issue Type and Team. It is the purpose of this measure.
Howevere, the Time dimension considers the date of the work log. When you filter data by the last 4 weeks, the report aggregates parent and sub-task hours that are logged in the past four weeks. If some sub-tasks were worked on earlier, those hours won’t appear in the report.
Please see the measure “Hours spent” and “Hours spent with sub-tasks” descriptions in the documentation: Time tracking measures.
Best,
Zane / support@eazyBI.com
Hi Zane,
thanks for your reply. Yes then my understanding was already correct.
Even though it seems not to behave for me like you described it. Maybe my screenshot was misleading.
In the following you can see that “hours spent” and “hours spent incl. sub-tasks” show 1-1 the same value even if there were records on the sub-tasks in the filtered time span.
Therefore I assume that there is a problem with this measure maybe in combination with the specific configurations I chose?
If you want, we can also have a look into it together?
Have a good start into the week.
Daniel
Hi @Daniel_Sander,
From the screenshot, I see that 5 hours of subtasks are imported (for Stories). If the subtasks issue type does not appear as a separate report row, it means no subtask issues match the page filter criteria and can be counted only as part of the parent issue (Hours spent with the subtasks).
The custom field “Teams” is most likely assigned only to the parent issue (Story) but not to the sub-tasks themselves. See the pictures below.
Best,
Zane / support@eazyBI.com
Hi @zane.baranovska,
you are absolutely right. What an easy solution. Thank you for your support.
Best regards,
Daniel
1 Like
