Forum Discussion
cohort
Hello,
I am trying to figure out how I can cohort data by a date. Here is an example of what I mean:
1. a form has been filled out on the 30th of June
2. it then became an MQL on the 30th of June
3. it then became an SQL on the 2nd of July
4. it then became an SQO on the 3rd of July
Now the counts for that lead should be like on the left-hand side not like the right hand side which it is right now:
How would I accomplish this?
Thank you very much in advance.
3 Replies
leela77 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Check if this can help
Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Analysis/ba-p/1393410
Power BI Cohort Analysis, Customer Retention %- https://youtu.be/qY1SDF1cwsgThank you very much for the links, amitchandak; however, I couldn't work it out with my set of data. Please find the dataset here: https://www.dropbox.com/scl/fi/qtfa8f8lfbzkhuy9jxyfu/sample.pbix?rlkey=s8dbz3a4mk85kd0a2zmsgboe7&dl=0
an additional note:
SQL is being calcualted:CALCULATE (
DISTINCTCOUNT ( fact_pipeline_events[pipeline_journey_id] ),
fact_pipeline_events[total_opportunity_created_events] > 0,
dim_product[business_unit_reporting] = "XYZ"
)
)
SQO is being calculated:
CALCULATE(
[# Opps Created - Discovery],
dim_product[product_name] = "xyz"
)
