I have attached sample data for the analysis. In the sample, there is a unique ID, sales opportunity name, Old value for pipeline stage, new value for pipeline stage, and how long it is in each stage of the pipeline funnel.
What I am trying to accomplish is to visually show the various opportunities moving through the sales pipeline funnel. For each period, I want to know how many opportunities moved out of each stage, how many opportunities moved into each stage. I also want to be able to see what specific opportunities moved in and out of each stage.
Let me know if there are any questions
MarkPipeline Stage Data.xlsx (67.7 KB)