Missed Team ’24? Catch up on announcements here.

×
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

How can I count the number of issues that have crossed their due dates in easybi

Suvarsha Rai
Suvarsha Rai
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
June 12, 2017

How can I count the number of issues that are in todo and inprogress state but have crossed their due dates in easybi

Answer
Watch
Like Be the first to like this
291 views

1 answer

0 votes
Kat Jansen
Kat Jansen September 11, 2019

Suvarsha, 

The code below should work and it will change based on any dimensions you put in Pages or Rows. If you are not using resolution, replace Issue resolution date with Issue closed date. It is not currently dependent on status, but you can add Status to Pages and filter accordingly.

NonZero(Sum(Filter([Issue].[Issue].Members,
DateCompare([Measures].[Issue due date],now())>0
AND isEmpty([Measures].[Issue resolution date])
), [Measures].[Issues with due date]))

Regards,

-Kat

Reply

Suggest an answer

Log in or Sign up to answer
Product apps
Apps & Integrations
TAGS
AUG Leaders

Atlassian Community Events

    See all events