Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
hey all,
im trying to calculate ticket resolution time without having to crossjoin the table with a DATE table.
Date Created | Work Order | Vehicle | Status | Date Completed |
1/5/2022 | 341364 | AB230060 | Closed | 1/10/2022 0:00 |
1/5/2022 | 341366 | AB260242 | Open | |
1/1/2022 | 341367 | AB210071 | Open | |
1/5/2022 | 341368 | AB250554 | Open | |
1/5/2022 | 341379 | AB230002 | Closed | 1/10/2022 0:00 |
1/5/2022 | 341380 | AB280023 | Open | |
1/5/2022 | 341394 | AB230002 | Open | |
1/5/2022 | 341395 | AB250426 | Open | |
1/5/2022 | 341396 | AB250642 | Open | |
1/5/2022 | 341398 | AB240121 | Open | |
1/5/2022 | 341399 | AB230071 | Open | |
1/5/2022 | 341404 | AB250692 | Open | |
1/2/2022 | 341472 | AB250691 | Open | |
1/2/2022 | 341479 | AB250570 | Open | |
1/2/2022 | 341481 | AB250311 | Open | |
1/2/2022 | 341486 | AB250309 | Open | |
1/2/2022 | 341488 | AB250683 | Open | |
1/1/2022 | 341490 | AB250460 | Closed | 1/5/2022 0:00 |
1/5/2022 | 341491 | AB250638 | Open | |
1/1/2022 | 341492 | AB290059 | Open | |
1/1/2022 | 341496 | AB250464 | Closed | 1/5/2022 0:00 |
1/2/2022 | 341497 | AB250645 | Open | |
1/2/2022 | 341686 | AB230137 | Open | |
1/2/2022 | 341688 | AB240112 | Open | |
1/2/2022 | 341693 | AB260054 | Open | |
1/5/2022 | 341779 | AB230009 | Closed | 1/10/2022 0:00 |
1/5/2022 | 341803 | AB250088 | Closed | 1/10/2022 0:00 |
1/1/2022 | 341811 | AB260116 | Open | |
1/1/2022 | 341844 | AB230307 | Open | |
1/5/2022 | 341867 | AB250450 | Open |
I'm hoping to end up with a Year/Month/Day table and see the trend of Mean Time To Resolution as a KPI
Hi @Alasharim ,
Is it convenient to share the results you are expecting regarding this data as a display? Not quite sure exactly what you are looking for.
Best Regards
Lucien