I want to generate a report that shows the following for each assignee that has the tasks(only) in "In progress" status only, I do not want any subtask to be shown. This report is only for tasks but when I create a report it pulls all assignees from task and subtask, I want to exclude subtask from this list adn want only tasks that are in in-progress status.
Assignee (only the ones who have a task assigned that is in progress status)
How can I add a filter under row->issues and columns->assignee to get only tasks that are in progress and assignees that are assigned to the tasks that are in progress?
to filter out only tasks, you can use "Issue type" dimension in Pages: in JIRA, tasks and sub-tasks have separate sets of issue types (i.e., subtask issue types could not be used for tasks, and vice versa). Select Issue Type dimension in Pages, and then select all parent issue types (multiple selection). In the result, only tasks (parents) will be counted in the report.
For only currently "In progress" issues, select "Status" dimension in Pages as well, and select "In Progress" value.
Also, select measure "Issues due" from "Measures" dimension together with "Assignees" dimension in columns to count all unresolved issues (according to Page selection) for each assignee. It is recommended always using some measure to be sure what is counted in the report (if none of the measures are selected, the default measure "Issues created" is used).
In rows, you can use "Issue" dimansion Sub-task hierarchy Parent level issues - then only tasks will be displayed in the rows. Still, "Issue type" filter in Pages is needed for not counting sub-tasks in the number of issues.
Ilze / email@example.com
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot