Insights report for sales cycle duration in Pipelines that we do not "win" the deals?
I am looking for a way to create an insights report that will give me the average time spent in 3 of the pipeline stages in a pipeline that we do not ever mark the deals as "won". I have a pipeline with 5 stages. The first stage is a holding stage and I don't want that included in the average sales cycle time. The 5th stage is our "won" stage where we leave the deals without actually winning them. So what I need is a report that tells me the average time it takes a deal to move through the middle three stages to get to the last one? (Once in the last stage we leave them there forever so I don't want that stage to throw off the average sales Cycle. Similarly, the deals sit in the first stage for a while sometimes without being worked on so I don't want that first stage to be included in the report.) Thanks for the help!!!