Forum Discussion
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
| Month | Count Ticket SLA breached | I do not need this column, I am putting it so that you can understand the calculation |
| Ene-21 | 0 | Id01 was created in January but breached SLA from February to July (expected resolution date to resolved date) |
| Feb-21 | 1 | Because id01 breached sla until resolved date (25/07), id02 was created but it just broke in March |
| Mar-21 | 2 | Because id01 breached sla until resolved date ( 25/07 ) and id02 breached sla until resolved date (20/05) |
| Abr-21 | 2 | Because id01 breached sla until resolved date ( 25/07 ) and id02 breached sla until resolved date (20/05) |
| May-21 | 2 | Because id01 breached sla until resolved date ( 25/07 ) and id02 breached sla until resolved date (20/05) |
| Jun-21 | 1 | Because id01 breached sla until resolved date ( 25/07 ) |
| Jul-21 | 1 | Because id01 breached sla until resolved date ( 25/07 ) |
| Ago-21 | 0 |
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.
3 Replies
- lbendlin
Super User
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.
