would really like to see the TWBX workbook and the data to answer this - the solution will depend on the data structure and number of sources but conceptually -
- calculate the datediff() between the task start and end - I would use fixed LOD
- then convert the datediff to a dimension
- Then count the orders
see the attached superstore example
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
order date diff.twbx 2.4 MB