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.
Time | Ticket Id | Agent | State |
1/1/2020 13:48 | 26625 | Chris Herbert | created |
1/2/2020 1:13 | 26625 | Chris Herbert | paused |
1/2/2020 14:23 | 26625 | Chris Herbert | resumed |
1/2/2020 14:25 | 26625 | Chris Herbert | closed |
1/2/2020 14:30 | 26625 | Chris Herbert | reopened |
1/2/2020 14:32 | 26625 | Chris Herbert | closed |
1/1/2020 14:22 | 26626 | Chris Herbert | created |
1/2/2020 1:13 | 26626 | Chris Herbert | paused |
1/2/2020 14:23 | 26626 | Chris Herbert | resumed |
1/2/2020 14:25 | 26626 | Chris Herbert | closed |
1/2/2020 5:39 | 26628 | Chris Herbert | created |
1/2/2020 5:41 | 26628 | Chris Herbert | paused |
1/3/2020 3:49 | 26628 | Chris Herbert | resumed |
1/3/2020 3:55 | 26628 | Chris Herbert | closed |
1/2/2020 6:08 | 26629 | Omar Salama | created |
1/2/2020 6:26 | 26629 | Omar Salama | paused |
1/2/2020 7:06 | 26629 | Omar Salama | resumed |
1/2/2020 7:07 | 26629 | Omar Salama | closed |
1/2/2020 9:07 | 26634 | Anmar Raouf | created |
1/2/2020 9:09 | 26634 | Anmar Raouf | paused |
1/2/2020 9:47 | 26634 | Anmar Raouf | resumed |
1/6/2020 8:43 | 26634 | Anmar Raouf | closed |
Expected Result(Minutes) | |||||
Ticket ID | Earliest Closed-Created_Date | Resumed- Paused | Last Closed-Reopened | Achieved SLA | Agent |
26625 | 1447 | 755 | 2 | 694 | Chris Herbert |
26626 | 1443 | 790 | 0 | 653 | Chris Herbert |
26628 | 1336 | 1328 | 0 | 8 | Chris Herbert |
26629 | 59 | 40 | 0 | 19 | Omar Salama |
26634 | 5736 | 38 | 0 | 5698 | Anmar Raouf |
Achieved SLA = (Earliest_Closed - DateCreated) - (ResumedDate - PausedDate) + (Last_ClosedDate - ReopenedDate)
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
hi
See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...
Hi,
You may download my PBI file from here.
Hope this helps.
So far this what i have
This will give diff between current and next step and then sum created, resume and reopened.
Create this as column
timediff = datediff(table[Time],minx(filter(table,table[Ticket Id] =earlier(table[Ticket Id] && table[Time] >earlier(table[Time])),table[Time]),day)
You can another column or measure an filter required steps
Appreciate your Kudos.
Still getting an error uisng earlier and including &&
Hello Ashish Mathur
Am trying your solution by the Last_Closed - Reopened Column is returning blanks only
Thank you
Hello Ashish Mathur
You are welcome.
Hi,
I can't say why. It is working fine in the file i shared with you.
Hi,
I am not sure whom you are replying to but have you tried my solution? I even share my solution file with you.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |