Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am trying to calculate the average time spent on packing orders per warehouse employee., based on the times they scan those shipments.
Here is sample data with my expected results:
OrderID | Scan Date/Time | Employee ID | Total Time Spent Per Day (Expected Result) |
6300946 | 1/4/18 9:47 AM | 51245 | 2 Min |
6301610 | 1/4/18 9:47 AM | 51245 | |
6301699 | 1/4/18 9:48 AM | 51245 | |
6302140 | 1/4/18 9:47 AM | 51245 | |
6302517 | 1/5/18 10:47 AM | 51245 | 6 min |
6302884 | 1/5/18 10:49 AM | 51245 | |
6303251 | 1/5/18 10:52 AM | 51245 | |
6303618 | 1/5/18 10:53 AM | 51245 |
Thank you for any assistance!
@eddya your post doesn't explain what is the logic to calculate "avg time spent" There should be time start or something like that.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I would like to calculate the average time spent on each order per person per day, assuming each scan is approx. 1 second. I am trying to divide the total duration by the # of orders, but I am not getting the expected results.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |