JQL filter for People who have not tasks in status "In Progress"

Question

Hi Community! Me and my team should create a filter to illustrate on dashboard all people in our department who have no tasks "In Progress".

Actually, data should be illustrated in a table mode like here:

On the left side amount of tasks in status "To-Do" and the right side shows number of tasks "In Progress". But we need a filter for illustration 0 (zero) tasks in status "In Progress" to realize who doesn't work at all or forget to update his issues on Jira.

Marlene Kegel - codefortynine · Answer

Hi @Maruf Mamurov,

Another option would be our Jira cloud app Quick Filters for Jira Dashboards.

We offer an advanced "Filter Counts" gadget, that enables you to display several filter counts on one gadget.

This is how the gadget could look at your dashboard:

And this is how the configuration could look like (as you can see it is possible to add more "Filter Counts" and/or icons per filter.

You can test more features of Quick Filters for Jira Dashboards on our demo dashboards.

Piyush A (STR) · Answer

Hi,

Unsure about the above one, but you may opt for the two-dimensional gadget in the dashboard.

X-Axis as Status

Y-Axis as Assignee

Filter: project=xyz and status in  (to-do, in-progress) order by status asc

This would give the assignee status count for In-Progress as ZERO too.