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 Jun...
Thank 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"
)