An error in report during the weekends

Questions & Answers
1

Screenshot 2020-07-24 at 17.33.59
Screenshot 2020-07-24 at 17.33.592902×1318 285 KB

Hello,

I’ve recreated the Issues burn-down in sprint chart, and it all looks great EXCEPT that on the weekend the cumulative issues resolved line gets disconnected and the remaining issues line jumps up. Any idea what I might be doing wrong?

Thank you!!

Tatiana

2

It seems a formula for Cumulative issues resolved has a filter checking out if there are any resolved issues. You might exclude this filter from the formula. It might be used to exclude any values in the future. I would suggest using this formula for cumulative issues resolved to retrieve values until today:

Case when
  DateAfterPeriodEnd(
    "Today",
    [Time].CurrentHierarchyMember)
  OR 
  DateInPeriod(
    "Today",
    [Time].CurrentHierarchyMember
  )
Then
Cache(
  Sum({PreviousPeriods([Time].CurrentHierarchyMember),
      [Time].CurrentHierarchyMember},
    [Measures].[Issues resolved]
  )
)
End

You would like to update the formula for Remaining issues as well. You would like to plot this line for future as well. Therefore, you would like to use another formula, instead of Cumulative issues resolved.

[Measures].[Issues history] -
Cache(
  Sum({PreviousPeriods([Time].CurrentHierarchyMember),
      [Time].CurrentHierarchyMember},
    [Measures].[Issues resolved]
  )
)

Daina / support@eazybi.com