Need help on priority

Hi great EazyBi Community,
I am new to EazyBI and need help regarding below report generation.
Find out count of Orphan stories per project,
My definition for orphan stories are follows:

1.Story is not belongs to any Epic then it becomes orphan story
2.Epic has 3 stories ,Story 1 ,Story 2 and Story 3.Story 1 and Story 2 are belong to Sprint 71 and Story 3 not inside of any sprint then Story 3 becomes a orphan Story
3.Epic is having Story 1 ,Story 2 ,Story 3 and Story 4 .Story 1,2,3 are inside of Sprint 71 and Story 4 belongs to Sprint 70 and it is in Open status then Story 4 becomes orphan story.
4.Epic is having Story 1 ,Story 2 ,Story 3 and Story 4 .Story 1,2,3 are inside of Sprint 72 and Story 4 belongs to Sprint 70 and it is in Closed status then Story 4 becomes orphan story.
5.Epic has Story 1 ,Story 2 ,Story 3 and Story 4 .Story 1,2,3 is inside of Sprint 72 and Story 4 belongs to Sprint 75 and it is in Closed status then Story 4 becomes orphan story.in Short we are looking for below report:

Thanks in advance,
Chhaya

Hi Team,
Can you please help us on priority. This is very important requirement for us.

Hi,

Hi,
There can be different solutions to how to count the orphan issues.
This example formula covers the following conditions:

  • The story not added to any sprint
  • The story epic not added to any sprint
  • The story is in the second future sprint after the active sprint

The formula is intended to show the count of orphan issues at the Project level (i.e., the Project dimension must be present in the report:

NonZero(Count(
  Filter ( --iterate all stories under all epics in the project
    Descendants([Issue.Epic].[Project].GetMemberByKey(
      [Project].CurrentMember.KEY
    ),[Issue.Epic].[Parent]),
    [Measures].[Issue type]="Story" 
    AND
    (
      IsEmpty([Measures].[Issue Sprint]) --story not added to any sprint
      OR
      IsEmpty([Sprint].[Sprint].getMemberNameByKey( -- story epic not addd to any sprint
          [Issue.Epic].CurrentHierarchyMember.Parent.get('Sprint ID')
        )) -- story with Epic in no sprint
      OR
      [Sprint].[Sprint].GetMemberByKey( -- story is in the second future sprint after active sprint
          [Issue.Epic].CurrentHierarchyMember.get ('Sprint ID')
      ).PrevMember.PrevMember.get('Status')='Active'
    )
    AND [Measures].[Issues created]>0
  )
))

Kindly,
Janis, eazyBI support

Hi @janis.plume ,
Thanks for your continuous support .i am getting wrong count(Null) for below :

  • The story not added to any sprint

  • The story epic not added to any sprint
    I tried below formula ,given by you :
    NonZero(Count(
    Filter ( --iterate all stories under all epics in the project
    Descendants([Issue.Epic].[Project].GetMemberByKey(
    [Project].CurrentMember.KEY
    ),[Issue.Epic].[Parent]),
    [Measures].[Issue type]=“Story”
    AND
    (

    IsEmpty([Sprint].[Sprint].getMemberNameByKey( -- story epic not addd to any sprint
        [Issue.Epic].CurrentHierarchyMember.Parent.get('Sprint ID')
      )) -- story with Epic in no sprint
    

    )
    AND [Measures].[Issues created]>0
    )
    ))

Please let me know ,if I am doing something wrong

Many Thanks,
Chhaya