It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

Hello,

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
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Expose your beautifully crafted Dashboard through the Jira Service Desk Customer Portal

  A picture is worth a thousand words, especially when you're trying to find relationships and understand your data. Here, Dashboards play a vital role in gaining insights from a variety of dat...

328 views 5 4
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you