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.
Hello,
Hopefully someone can help with my current problem. I would like to calculate the Avg Down Time Between Calls by Employee for a KPI report.
My dataset is a combination of csv. files that are weekly call logs that inclue numerous employees. The csv. files are saved in a folder. The folder is then the source of my PowerBI query.
Data set includes a start of call and call duration or talk time length but not end of call. Previously I have been sorting all of the data by employee and then calculating the end call time in excel. I can then subtract the calculated end time from the Next Calls Start Time to get a "Wrap Duration" or time between calls.
Is this something I can do in Power BI? Any help is greatly appreciated!
Solved! Go to Solution.
Sounds very very similar to Mean Time Between Failure...
See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...
Thank you @Seward12533 and @Greg_Deckler for your replies!
Greg it is very similar to your Mean Time Before Failure article. I think it is going to work with my dataset/problem.
Thanks again for the help! And your article : )
Sounds very very similar to Mean Time Between Failure...
See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...
I would try to add a column that will calculate the MIN of all calls by that same person that start after the start time of the current slide.
End Time = CALCULATE(MIN(table[Start Time]),table[Start Time]>[Start Time],table[AgentID=[AgentID]))
or something like that..
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 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |