Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@jtcm4568 , 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))
@jtcm4568 , 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!
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |