Issues count due YTD

[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