for calculated members you can always explore our Demo account: https://eazybi.com/accounts/1000/cubes
It has a lot of good examples for calculated members
Here you would need a calculated measure that iterates through Issues dimension members to find issues that were removed from the sprint
NonZero(
SUM(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Sprint].CurrentMember.Name = [Measures].[Issue sprints]
AND
[Measures].[Sprint Issues committed]>0
),
[Measures].[Sprint Story Points committed]
)
)
Don’t forget to enable “Nonempty” cross join when selecting this calculation.
I tried using solution for #3. I am getting error as noted below.
To clarify the ask I have is- Have ability to calculate what is Core Commitment for just an Active sprint excluding issues/ points which come from previous sprints. Probably need two measures, one for Issue Count, another for SP.
Please advise.
#ERR: mondrian.olap.fun.MondrianEvaluationException: Exception while executing function NonZero: mondrian.olap.MemoryLimitExceededException: Mondrian Error:OutOfMemory used=705338208, max=716177408 for connection: Jdbc=jdbc:postgresql://cft-jiraeazybi.cpxlp0s4s23s.us-east-1.rds.amazonaws.com:5432/jiraeazybi?tcpKeepAlive=true&ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory&sslmode=verify-full; JdbcDrivers=org.postgresql.Driver; UseContentChecksum=true; CatalogContent=’<?xml version="1.0" encoding="UTF-8"?> <Table na
Calculated measures should be created only in “Measures” dimension.
In the 3.point, make sure that you save your report with “Nonempty” cross join before selecting the report and doublecheck that your formula is as follows:
NonZero(
SUM(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Sprint].CurrentMember.Name = [Measures].[Issue sprints]
AND
[Measures].[Sprint Issues committed]>0
),
[Measures].[Sprint Story Points committed]
)
)
Earlier comment was about creating Last 5 Sprints measure in Sprint Dimension. Let me know what maybe the resolution there. or am I doing something incorrect?
So can you provide what shall I use for ‘Last 5 Sprints’.
Also, please provide formula for finding out SP/ Issues committed only in a given sprint excluding any prior sprints carryover issues/ SP. and will this be created under ‘Calculated Measure’ or in ‘Sprint Dimension’. Sorry, a little confused, hence seeking clarity further.
Hi,
Try this formula for a calculated measure “Last 5 closed sprints”
Case when
[Sprint].Currentmember.Level.Name = 'Sprint'
Then
Case when [Sprint].CurrentMember.Name <> '(no sprint)'
Then
NonZero( Rank(
[Sprint].CurrentMember,
Tail( Order(Filter(
[Sprint].[Sprint].Members,
[Measures].[Issues created] >0
AND [Measures].[Sprint closed?]="Yes" -remove line to include all sprints with startdate
),
[Sprint].Currentmember.Get('Start date'), BASC) --this is the property by which sprints are sorted
,5))) --use other value to show more/less than 5 sprints
End
Else
[Measures].[Issues created]
End
And use this code to count issues that were committed only to the displayed sprint.
When using code for calculating SP for work committed only in a given sprint, I am getting error. I am using it as a Calculated Measure. what should I do differently?
Also, how is ‘Last 5 Sprints’ measure expected to be used? my thought is to be able to use it to see performance / data for last 5 sprints for any team/ teams. How do I execute that?
Can you save the report with the error when calculatng work commited in new report and share the definition of the report? And let us know what kind of error do you get exactly?
Please find the “last 5 closed sprint” used in the report:
hi, this is the error I face. I am not sure if I can share report definition as it may contain employer specific data which I am not permitted to share externally.
If you find the report definition sensitive, please reach out to support@eazybi.com and provide it via email to us.
Without that context, it is hard to tell correctly what went wrong with your calculation.