Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Show and Tell
Tips and Tricks
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Anonymous ,


I don't seem to quite understand what you are looking for. For stage1, can you give an example of how to find the average time for the corresponding month based on the given result table.


Looking forward to your reply.


Best Regards,
Henry

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi v-henryk-mstf The time of each stage is the time of the current until the next stage time. Stage time = Next stage time (in chronological order) - current stage time (in chronological order). Note: the stages are not necessary in order, e.g. the process can start in stage 1 and the next would be stage 4.