2 Replies Latest reply: Jun 14, 2017 10:42 AM by Wallo Atkinson RSS

    Build a Churn Model

    Dave Melillo

      This is a conceptual question.

       

      I have three fields SUBSCRIPTION START DATE and SUBSCRIPTION END DATE and SUBSCRIPTION AMOUNT


      I want to be able to SUM the SUBSCRIPTION AMOUNT month by month to show churn.

       

      My issue is that I cannot use the start or end date fields as my date column ... I feel like I need to make a new date. Also, I am not sure how to write the set analysis to evaluate between these two dates.

       

      The set analysis below has worked for me, but I am not sure how to represent this OVER TIME that is now start or end date.

       

      =sum({$< Won ={'1'},[Subscription End Date]={">=$(=Date(Today(),'MM/DD/YYYY'))"}>} [ARR-equivalent (converted)])

       

      Any help is appreciated.

       

      - dave