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.
Hi,
I've tried several posts regarding this issue, but I can't get them to work properly for me.
I need to determine the time (In minutes) to response by ticket (and eventually, in a different column, if it met SLA) for business days and hours (Monday - Friday, 6am - 6pm).
I have a table with the ID, Open Date and Response Date (see below)....
Thank you
hi @Anonymous,
I have had a look at the sample values you have provided, and I am probably a bit slow here, but I can't get the numbers to add up.
For ID=1 and ID=2, should they not both be 11 minutes?
And how do you get only 82 minutes for ID=5? From 15:38 to 18:00 there's 142 minutes and another 60 minutes from 06:00 to 07:00 the following the day, so a total of 202 minutes for ID=5, according to the information you have provided
cheers,
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |