Hi community!
I would like to calculate the average time for each article that we should consider until the order is placed.
I have an order table that shows me for each order (2-year history) the date for each status.
Not every article has the same number of statuses.
| Article |
Order Nr |
Date |
Status |
| A |
1 |
01.01.2021 |
5 |
| A |
1 |
02.01.2021 |
10 |
| B |
2 |
02.01.2021 |
4 |
Then I have a second table that shows me if an order was completed and when:
| Order |
Type |
Date |
| 1 |
Ready |
05.01.2021 |
| 2 |
Ready |
04.01.2021 |
Now I would like to calculate the average time that was used to proceed an order from the beginning to the end.
Beside that I would also like to know the average time that is left based on the status.
In the end, I would like to get something like this as an output:
| Article |
Status 5 |
Status 10 |
Status 15 |
Total Time |
| A |
5 |
4 |
3 |
5 |
| B |
|
4 |
3 |
4 |
How would you build / calculate something like this?
