It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

easyBI Transition status by last occurrence for last 10 days

Alexandra S I'm New Here Mar 26, 2019

Hello,

I would like to show in a report cumulative SPs for daily transitions for specific statuses (i.e dev complete, test complete, done) for the past 10 days, but taking into consideration the last date  of the transition.

For example, if I have a user story that moves to dev complete, then test complete and back to dev complete the code below counts in both dev complete and test complete. I would like it to be counted only in the dev complete, because that is the last transition of the day for that issue.

So the report created so far is the following:

- on the rows, added the "Time" measurement with the following calculated member "Last 10 days":

Aggregate

(Filter([Time].[Day].Members,

DateBetween([Time].CurrentHierarchyMember.StartDate,'10 days ago', 'today')))

- on the columns, added the "Transition" measurement, added  calculated fields for transitions: SPsDevComplete, SPsTestComplete

SPsDevCompete

Sum(

Filter(

Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),

([Measures].[Transitions to status issues count],

[Transition].[In Dev => Dev Complete])>0

),

[Issue].CurrentMember.get('Story Points') )

SPsTestComplete

Sum(

Filter(

Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),

([Measures].[Transitions to status issues count],

[Transition].[In test => Test Complete])>0

),

[Issue].CurrentMember.get('Story Points') )

Can someone advise?

 

Many thanks.

0 answers

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Next-gen

Introducing subtasks for breaking down work in next-gen projects

Teams break work down in order to help simplify complex tasks. This is often done iteratively, with tasks being broken down into smaller tasks and so on until the work is accurately captured in well-...

8,373 views 25 38
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you