Issues count due YTD

[rajeshbabu.suraparaj]

Hi,

I have a field called due date, which needs to be filled by assignees to indicate the issue is expected to be closed.
Based on this field, I want to create a report that shows the issues that are open and have due dates before today, priority wise.
How can this be created ?

[zane.baranovska]

Hi @rajeshbabu.suraparaj,

You can create a calculated measure that would check on unresolved issues with due dates in the past.
You might want to start with the report template “Issues due and overdue” from the Demo account: Issues due and overdue - Issues - Jira Demo - eazyBI.

Here are other Community topics on similar use cases to check on overdue issues:

New report - Issue Overdue

How can i create a report that return the result based on JQL below: project in (ABC) AND status not in (XYZ) AND (“End date” < now() OR “End date” is EMPTY) AND issuetype not in (AAA) ORDER BY key, status, “End date” Result view = gauge my difficulty is in creating a new “Define new calculated member” that uses the ENDDATE field according to JQL. Exemple: [gauge] Thanks.

Help Display Tasks Past Due based on a Custom Field

Hello, I’m trying to create a new measure that will display the tasks that are in a status of In Progress and past due based on a date entered in a field called Target Prod/Completion Date compared to todays date along with displaying the number of days the task is past due. When I attempt the code below, it includes the tasks that don’t have a Target Prod/Completion Date and the tasks that have a future Target Prod/Completion Date. What am I missing to exclude those two items? NonZero(Aggregat…

Best,
Zane / support@eazyBI.com

[rajeshbabu.suraparaj]

@zane.baranovska , Thank you. Will take a shot at this.