Filter out on table for overdue issues

Questions & Answers
,
1

i am using easybi pulling info from jira and want to make a report that will only show me issues that meet either of these two conditions 1. The due date has to be before today and it has no date complete 2. The due date has to be before the date complete date. Date complete is a custom field that i have in jira where people will insert the day they completed their issue. I want to see an issues table that will only populate the issues that meet the criteria i mentioned above. This is an important part of my reporting that I am making so any help is appreciated.

Thank you in advance.

2

Hello @Hiro,

Thanks for posting your question!

Based on your description, we suggest using the following MDX:

CASE
WHEN
DateCompare(
  [Measures].[Issue due date],
  "today"
) < 0
AND IsEmpty([Measures].[Issue Complete Date])
OR
DateCompare(
  [Measures].[Issue due date],
  [Measures].[Issue Complete Date]
)  < 0
THEN
1
END

This code will return value “1” if the issue matches one of the two conditions:

  • The issue is past due and not yet complete or

  • The issue’s completion date is later than its due date.

I hope this helps!

Best,
Marita / support@eazybi.com

3

Hi thank you so much for the reposnse could you guide me to where i should input this code so i can get a graph that will only shopw me the issues in a table that shows the issues that meet these conditions

4

Hi @Hiro,

You can create a new calculated measure under Measures. Here’s an instruction on how to do it: Calculated measures

image
image1782×982 128 KB

Once you have created this new measure, you can select it and use it in your report.

Let me know if you have any additional questions.

Best,
Marita support@eazybi.com