Forum Discussion

xerikx's avatar
xerikx
Regular Visitor
4 years ago
Solved

Accumulated Sla Breached

Please could someone help me to elaborate the table to calculate the accumulated, I have no idea how I could do it or how to approach it   My Data   I want to make this table or graph   ...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago
    Count Tickets SLA Breached = CALCULATE(COUNTROWS('Table'),'Table'[Resolved Date]>Min(Dates[Date]),'Table'[Created Date]<Max(Dates[Date])-25)

    See attached. This also works on day level granularity.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago
Count Tickets SLA Breached = CALCULATE(COUNTROWS('Table'),'Table'[Resolved Date]>Min(Dates[Date]),'Table'[Created Date]<Max(Dates[Date])-25)

See attached. This also works on day level granularity.

  • xerikx's avatar
    xerikx
    Regular Visitor
    4 years ago

    Excellent solution, another question how can i show the ID for each month?

    Slicer Month: Selected Mar-21

    Result Table:

    Id      Created
    id01    10/01/21
    id02    11/02/21
    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      Those data points do not depend on the slicer. Create a separate table visual that has only Id and Created columns.