Task Eazybi report for jira/confluence

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)

Task key

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?


1 answer


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 /  support@eazybi.com

Suggest an answer

Log in or Sign up to answer
Community showcase

Scrum Roles Explained: the Do's and the Don'ts

Hello Community,  Today we are going to talk about the three Scrum Roles. There is the Development Team, the Scrum Master and the Product Owner. In my opinion these three are all really impo...

69 views 0 4
Read article

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you