Creating a report that identifies all epics that went from "draft" to any other status in the last week

Questions & Answers
1

Hello, I’m new to EazyBI and working on creating a report that shows all epics that changed from draft to any other status in the last week. Any recommendations on how to achieve this? I’m far more experienced with Excel but I’d like to use this as a updating dashboard. Thanks!

2

Hi @SamFadams
​Welcome to eazyBI community!
​
​For your use case I recommend defining a new calculated measure in Measures dimension (Calculated measures and members) with the formula below and check if it returns the expected results
​

​([Measures].[Transitions from status issues count],
[Transition Status].[Draft],
[Issue Type].[Epic],
[Time.Weekly].[Week].CurrentDateMember.PrevMember)

Best wishes,

Elita from support@eazybi.com