Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello!
It's me again....lots of questions as I figure this all out.
I have a table full of information about the number of times someone answered the phone, and how many seconds that interaction took. It takes the following form:
DateTime | Group Name | Number of Calls | Total length of calls in seconds |
2021-01-01 08:00:00 | GroupA | 46 | 1,080 |
2021-01-01 08:00:00 | GroupB | 412 | 7,211 |
2021-01-01 08:30:00 | GroupA | 12 | 300 |
I first created a new Measure:
AverageHandleTime = DIVIDE(SUM([Total Length of Calls]),SUM([Number of Calls]),0)
That works wonderfully...but I just get the number of seconds, and I can't seem to find a way to represent that as a timestamp.
According to a few resources I found online, I have to create a 'Duration' column in my table. I've done that, as structured below:
Date | Group | Number of Calls | Length of Time | Average Call Length | Duration of Avg Call Length |
2021-01-01 08:00 | GroupA | 46 | 1,080 | (1,080)/(46)=23.47 | 00:00:23 |
2021-01-01 08:00 | GroupB | 412 | 7,211 | 17.52 | 00:00:18 |
Now, however, if I put the numbers into a column chart, in order to get a "reasonable" number for my Y axis, I have to do an Average (of my Average). This feels wrong.
Is there an easier/better way to do duration that I'm missing? Or a better way to crack this nut?
Thanks!
Josh
Solved! Go to Solution.
@Anonymous , You should create a measure on top of this measure AverageHandleTime, and use that
time(quotient([AverageHandleTime],3600) , quotient(mod([AverageHandleTime],3600),60), mod(mod([AverageHandleTime],3600),60))
@Anonymous , You should create a measure on top of this measure AverageHandleTime, and use that
time(quotient([AverageHandleTime],3600) , quotient(mod([AverageHandleTime],3600),60), mod(mod([AverageHandleTime],3600),60))
This was brilliant, and for some reason, this kind of solution came up in exactly zero of my searched for how to figure out duration as a measure. Thank you!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
76 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |