I’m trying to figure out how to filter a Jira issue count measure for only tickets that engineers actually work on directly, which for us would include mostly sub-tasks, but also issues (only Story/Task/Bug) with no sub-tasks. Suggestions on how to approach this? I would guess it will be a calculated member of the Issue dimension which I would use in Pages maybe?
Thank you for the question!
Usually, creating a calculated member in Issues dimension is not suggested, as it is a large dimension and it could cause reports performance issues.
One option is to create a calculated measure (in Measures) that iterates through issues, filters out all issues without sub-tasks (in other words, parent issues without subtasks, as well as sub-tasks themselves) and then sums them up.
For getting totals of other measures, use the needed measure instead of Issues created.
Ilze / firstname.lastname@example.org
How can I filter all the subtasks that come from the stories and not from the tasks?
You may want to import linked issue type dimension Parent Issue type: Issue link field dimensions, see an example of setting for “Parent Fix version” (change name and source dimension name).
Then, in the report, you would select “Parent Issue type” dimension in Pages and select “Stories” - now the report would be created based on issues having parent “Stories”. Additionally, select the “Issue type” dimension in Pages if you need to specify only particular sub-task types.