eazyBI measured SLA Status field problem

[İclal Aslan]

I have 4 statuses, and I measure the time spent until an issue passes through each status. If the issue is still in that status, I measure the time it has remained there. Each status has its own SLA time — for example, status X has 1 business day while status Y has 3 business days.

I also have a field called product choice, and one of the statuses SLA is determined based on that. For instance, if product A is selected, the SLA is 1 business day; if product B is selected, the SLA is 3 business days.

I can calculate and display these values on the screen. If none of the 4 statuses have breached their SLA, it should show Met; if even one has breached, it should show Breached; and if the issue has not yet entered any of the statuses, it should show Not measured yet. But it’s currently showing wrong data.

This is my current formula :

"SLA Breached",

IIF(
  -- 4.1–4.4 threshold kontrolleri
  (
    CoalesceEmpty((
      [Measures].[Days in transition status],
      [Transition Status].[4.1 Fizibilitenin hazırlanması],
      [Time].CurrentHierarchy.DefaultMember
    ),0) +
    CASE WHEN [Measures].[Issue status] = '4.1 Fizibilitenin hazırlanması'
      THEN DateDiffDays([Measures].[Issue status updated date], Now())
      ELSE 0 END
  ) >= 3
  OR (
    CoalesceEmpty((
      [Measures].[Days in transition status],
      [Transition Status].[4.2 Fizibilite onayı],
      [Time].CurrentHierarchy.DefaultMember
    ),0) +
    CASE WHEN [Measures].[Issue status] = '4.2 Fizibilite onayı'
      THEN DateDiffDays([Measures].[Issue status updated date], Now())
      ELSE 0 END
  ) >= 3
  OR (
    CoalesceEmpty((
      [Measures].[Days in transition status],
      [Transition Status].[4.3 Teklifin hazırlanması],
      [Time].CurrentHierarchy.DefaultMember
    ),0) +
    CASE WHEN [Measures].[Issue status] = '4.3 Teklifin hazırlanması'
      THEN DateDiffDays([Measures].[Issue status updated date], Now())
      ELSE 0 END
  ) >= 2
  OR (
    CoalesceEmpty((
      [Measures].[Days in transition status],
      [Transition Status].[4.4 BT Teklif onayı],
      [Time].CurrentHierarchy.DefaultMember
    ),0) +
    CASE WHEN [Measures].[Issue status] = '4.4 BT Teklif onayı'
      THEN DateDiffDays([Measures].[Issue status updated date], Now())
      ELSE 0 END
  ) >= 1,

  "SLA Breached",
  "SLA Met"
)

)
)

[Marc - Devoteam]

Hi @İclal Aslan 

Is best with such a specific question to reach out to the apps own community or support

https://community.eazybi.com/ or https://eazybi.com/contact