% of Issues resolved within Custom Field Date

Greg · July 23, 2024, 11:04am

Hey guys,

Sorry if this is already answered somewhere, but I’m having issues finding a solution.

I am looking to create the below for a separate report that shows issues resolved within a custom field “deployment target date”.

I have this created which populates a column with a true or false if the date is met.
CASE WHEN
DateCompare(
DateWithoutTime([Issue].CurrentMember.get(‘Target Deployment Date’)),
DateWithoutTime([Measures].[Issue closed date])
)>=0
THEN “True”
ELSE
“False”
END

This is great if I want to drill down to an individual level, but I now need to present data at a Monthly level and I’m struggling to find what % of my issues were resolved within that “target date” at the parent level.

Would really appreciate some assistance. The report will likely have Deployment Type as a page along with Time.

Many thanks

Greg

Greg · July 23, 2024, 11:05am

Essentially, I’m looking to create something like this. With the % giving what was resolved within target date.

ilze.mezite · July 29, 2024, 10:49am

Hi, @Greg

The problem solving continuous in private conversation, but for the others, I’ll share the first solution here:

Thank you for reaching out to eazyBI.

Please consider using the Descendants (read more here: Descendants) to go through the issues, filter out the ones that met the criteria, and then divide by all issues closed in the period.

The formula then should look like this:

Sum(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
  DateCompare(
    DateWithoutTime([Issue].CurrentMember.get('Target Deployment Date')),
    DateWithoutTime([Measures].[Issue closed date])
    )>=0   
  ),
 [Measures].[Issues closed]
)
/
[Measures].[Issues closed]

Then, in the Bar chart, please select this new measure, choose separate axes, and type - scatter.

Kindly,
Ilze