Forum Discussion
Find Average Time per Month
Hi, I want to find an average time for one stage to another per month. I have this data below which are the date and time of each stage, the reference number that is the client, and the stage of th...
Hi Anonymous
Based on above data, what is your output date, please provide
Hi PijushRoy I would like to have an output as below, with the average time (in minutes) by Stage, by month. Thanks
| Stage 1 | Avg Time | Avg Time | Avg Time | Avg Time | Avg Time |
| Stage 2 | Avg Time | Avg Time | Avg Time | Avg Time | Avg Time |
| Stage 3 | Avg Time | Avg Time | Avg Time | Avg Time | Avg Time |
| Stage 4 | Avg Time | Avg Time | Avg Time | Avg Time | Avg Time |
| Stage 5 | Avg Time | Avg Time | Avg Time | Avg Time | Avg Time |
| Stage - Other | Avg Time | Avg Time | Avg Time | Avg Time | Avg Time |
| Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 |