Filter resources by greater due date

Question

Hello

I would like to create filter for assignee where it shows individual assignee greatest due date, for example a person is assigned with 3 task

Task 1: Due Date (Jan, 1, 2023)

Task 2 Due Date (Jan 10, 2023)

Task 3: Due Date (Jan 15, 2023)

The Filter will only Jan 15, 2023, which will help to understand when this resource is getting free.

Hannes Obweger - JXL for Jira · Answer

Hi @Mudassir Hasan

if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a view like e.g. this in just a couple of clicks:

This is really just one of a virtually endless number of possible views and reports; you can also view and group by any other issue fields, configure different sum-up styles, etc. etc.

Any questions just let me know,

Best,

Hannes

Danut M _StonikByte_ · Answer

Hi @Mudassir Hasan,

As mentioned already, this is not something that you can do by using a filter or JQL.

I would like to propose another possible solution in addition to the ones already mentioned by @Trudy P Claspill and @Bhanu, which you should definitely try.

If you take into consideration the possibility of installing an app, our Great Gadgets app includes a Pivot Table & Pivot Chart gadget that can be configured to display a timeline by Due Date for the issues assigned to your team members.

The columns represent the due dates of the issues. The lines are given by the issue assignees. The cells indicate the number of issues assigned to that persons (from row) that have the Due date (from column). This way you get a type of calendar that allows you to easily determine the maximum Due date for each person - the column of the last non-empty cell on each row.

To achieve this, you have'll to configure the gadget like this:

Danut.

Bhanu_ihv087 · Answer

Hi @Mudassir Hasan

To help with this, We use Jira Dashboards to track the Resource load for the Team Members

We use Issues Calendar Gadget to show the issues Due on the Day. Issue Statistics Gadget and Filter Results are really helpful too to show the number of tickets assigned to the users easily.