Time to perform activity measure

i have attached model below. i am trying to measure time spent performing picking activity. There is no start or stop time for each pick scan so i am measuring the time between the first and last pick scan for an operators shift on a specific order to calculate raw pick time for that order. this works great most of the time, but sometimes operators will start an order, then go do other things for an hour or a few hours, then come back to pick that order. this results in the measure counting several hours spent picking that order when in reality it may have taken as little as 5 minutes time to pick that order. i am hoping someone here has a better way to calculate the pick time. the measure i am specifically looking for help with is the rawpicktime measure under my time intelligence measure group.

OperatorActivity - Anon.pbix (872.0 KB)

Hi @kritchie, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.

  • Use the forum search to discover if your query has been asked before by another member.

  • When posting a topic with formula make sure that it is correctly formatted to preformated text </>.

  • Use the proper category that best describes your topic

  • Provide as much context to a question as possible.

  • Include demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

I also suggest that you check the forum guideline https://forum.enterprisedna.co/t/how-to-use-the-enterprise-dna-support-forum/3951. Not adhering to it may sometimes cause delay in getting an answer.

Hi @kritchie

Looking at the Model and Data, don’t think it is possible to determine the actual time for Pick up unless there is some field in Data to identify Idle time.

One option will be to limit the maximum time for Pick to some specific number say 10 minutes and if any Pickup duration is more than it, then calculate as 10 min only.

Thanks
Ankit Jain