Report from previous days

Questions & Answers
1

Hello everyone, community! I hope you’re all doing well. I’m trying to create a report, a table, that shows me the issue types for a project called “Defects” and that they’ve changed to the “Ready to Test” status on previous days, except today. It’s getting complicated because I don’t know why some issues aren’t listed. They meet all the requirements. I even checked the time the status changes to see if it’s compliant 24 hours a day. I hope I can be clear, and if you need more details, I’m happy to.

2

Hi @Nicolas_Mayans
Try this code to count issues that transitioned to status “Ready to Test” yesterday:

(
[Measures].[Transitions to status issues count],
[Transition Status].[Ready to Test],
[Time].[Day].DateMember("yesterday")
)

And this code to count issues that transitioned before today

SUM(
  PreviousPeriods(
  [Time].[Day].DateMember("today")
  ),
  (
    [Measures].[Transitions to status issues count],
    [Transition Status].[Ready to Test]
  )
)

Just keep in mind if the same issue went to status “Ready to Test” week ago and today (multiple times), it would still be counted with the second formula

Martins / eazyBI