Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,I would really appreciate if someone helps me out with query
I am working on ticket analysis of some company where I have ticket audit data,I have to calculate the days spent by one departement on one ticket at the end of the lifetime of the ticket and then visualize the average of each department.
Same logic I have to use on the Satus as well where I have to calculate the average time for a ticket in one Status,status of the ticket can be New,In Progress,Waiting For Customer and Closed.
I am attaching the sample data to answer the question for 3 Tickets,where two departments are present Settlement and Schedulling
Created-Date of Creation of the Ticket
Due Date-Due date to Close the Ticket
Modiefied-any change in status or department shows the date in modified column for one ticket.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |