Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi
I'm trying to calculate average talk time, and am having issues where the call goes into a new day:
My measure is:
Can anybody see what is wrong with my formula?
Thanks!
Try RETURN DAXDay&":"&TIME(DAXHours, DAXMin, DAXSecond)
--Nate
Unfortunately, that still returns strange results:
I can see the second part of the calculation has worked correctly. The top call is indeed 17 minutes long, but the first half of the calculation is still adding almost a month to the call time...
As you can see from the next result down on my screenshot, all my other calls are accurate. It's just when the date changes mid-call it can't work it out.
Hello @M_B_
Have you tried to substract call end time with call start time and represent the value as seconds?
Hi @Anonymous
I thought that was essentially what my DATEDIFF was doing within this sum?
What formula would I need for a straight subtraction End Time-Accepted Time which would return a value in seconds?
User | Count |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
28 | |
19 | |
13 | |
11 | |
7 |