Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Build a Churn Model

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

2 Replies
sunny_talwar

May be using While loop in script to create a date field from start and end date

Loops in the Script

Anonymous
Not applicable
Author

Similar to Sunny's response.......

Creating Reference Dates for Intervals