Sales Pipeline Stages

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

Thank you,
MarkPipeline Stage Data.xlsx (67.7 KB)

Hi @msedlak, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.

  • Use the forum search to discover if your query has been asked before by another member.

  • When posting a topic with formula make sure that it is correctly formatted to preformated text </>.

  • Use the proper category that best describes your topic

  • Provide as much context to a question as possible.

  • Include demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

I also suggest that you check the forum guideline How To Use The Enterprise DNA Support Forum. Not adhering to it may sometimes cause delay in getting an answer.

Hello @msedlak.

In the description you say that there is a column with unique data, but according to the image below as you can see that column a does not have unique data.

In that order of idea I don’t know if you will consider the measures

  1. Opportunity = COUNT (‘Pipeline Stage Data’ [History Sort Key])
  2. Opportunity = DISTINCTCOUNT (‘Pipeline Stage Data’ [History Sort Key])

Anyway, I tried to bring these visualizations that I thought can help us in solving the problem at hand.

Finds download files
Pipeline Stage Data.xlsx (68.8 KB)
Pipeline Stage Data.pbix (150.8 KB)

Let me know if there are any questions

Best regards
Gifted

Thank you for your help. After doing further research on EDNA, I realized there was a name for this type of analysis; Events in Progress. I was able to work through it using that logic. I couldn’t figure out how to edit my post. I do appreciate your time on this.

1 Like