Forum Discussion
Historical Data Reports
Hi, Would someone be able to kindly help me with this problem I have a data table which contains the created date and completion date of a unique work order I need to look back over time ...
Hi Zoe
Thank you for taking the time to resond
Apologies - yes you are right it should be 3 orders not completed for August
The cycle time is calcuated by totalling the time to complete and dividing by the total number of orders
Many Thanks
Hi KG1
I am still can't get the average result like you, so if possible, could you please write the expression for me. You could refer to my sample.
In addition , if possible, could you please inform me more detailed information for your second problem? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find i