calculate average time between two dates based on status
I want to calculate the average time between two dates based on the status. Don't know how to write correct syntax for that.
Please refer the attachment for your reference. You will get clear picture what exactly I am looking for.