Display the quartile from the date the sprint ends

Questions & Answers
1

Hello, I’m trying to bring up the quartiles for sprints, but I’m not able to bring up a single line, eazybi identifies the sprint start date as a quartile and the sprint end date as another quartile.

Is there any way to present the quartile for the sprint end date?

Example: If my sprint started on 09/18/2023 and ended on 10/06/2023, the 4th Quartile should be displayed.

Below is an image for better understanding.
Thank you very much.

evidence
evidence1053×231 8.84 KB

2

I made this, but I want Agregate per quartile Sum (Story Points Completed) / Sum (Story Points Commited).
exemple: (Completed: 73+58+50+59+67)= 307 / (Commited: 72+71+42+57+72)= 314 = 97,8% is referent Q1.

image
image721×517 11.3 KB

Could you help me?

Thanks. :slight_smile:

3

Hi @plmoro
Welcome to the eazyBI community and thanks for posting your question!
I recommend defining a new calculated measure with the formula below. Make sure you select the Percentage formatting before you save the formula (Calculated measures).

[Measures].[Sprint Story Points completed]/
Sum(
  Filter(
    DescendantsSet([Sprint].CurrentMember,[Sprint].[Sprint]),
    DateInPeriod(
      [Measures].[Sprint actual end date],
      [Time].CurrentHierarchyMember
    )
  ),
  ([Measures].[Sprint Story Points committed],
  [Time].CurrentHierarchy.DefaultMember)
)

Best wishes,

support@eazybi.com

1 Like
4

the formula worked perfectly, thanks :wink:

1 Like