Calculating ticket resolution time on daily/monthly bases

[Alasharim]

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

[v-luwang-msft]

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