Forum Discussion
Calculating Down Time Between Calls
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!
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/339586
3 Replies
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..
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/339586
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 : )
