Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Alasharim
Frequent Visitor

Calculating ticket resolution time on daily/monthly bases

hey all,

 

im trying to calculate ticket resolution time without having to crossjoin the table with a DATE table.

 

Date CreatedWork OrderVehicleStatusDate Completed
1/5/2022341364AB230060Closed1/10/2022 0:00
1/5/2022341366AB260242Open 
1/1/2022341367AB210071Open 
1/5/2022341368AB250554Open 
1/5/2022341379AB230002Closed1/10/2022 0:00
1/5/2022341380AB280023Open 
1/5/2022341394AB230002Open 
1/5/2022341395AB250426Open 
1/5/2022341396AB250642Open 
1/5/2022341398AB240121Open 
1/5/2022341399AB230071Open 
1/5/2022341404AB250692Open 
1/2/2022341472AB250691Open 
1/2/2022341479AB250570Open 
1/2/2022341481AB250311Open 
1/2/2022341486AB250309Open 
1/2/2022341488AB250683Open 
1/1/2022341490AB250460Closed1/5/2022 0:00
1/5/2022341491AB250638Open 
1/1/2022341492AB290059Open 
1/1/2022341496AB250464Closed1/5/2022 0:00
1/2/2022341497AB250645Open 
1/2/2022341686AB230137Open 
1/2/2022341688AB240112Open 
1/2/2022341693AB260054Open 
1/5/2022341779AB230009Closed1/10/2022 0:00
1/5/2022341803AB250088Closed1/10/2022 0:00
1/1/2022341811AB260116Open 
1/1/2022341844AB230307Open 
1/5/2022341867AB250450Open 

 

 

I'm hoping to end up with a Year/Month/Day table and see the trend of Mean Time To Resolution as a KPI

1 REPLY 1
v-luwang-msft
Community Support
Community Support

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

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.