Hi new user here,
I have a question about getting the membership length of our customers and I am doing this as a beast mode for a card:
- I need to find the start date of membership
- I need to find the end date of membership
- Finally the avg time they have been a member
I used the following case statement to try and find the start and end dates:
- StartDate - Beast mode calculation
- CASE WHEN
countasUWCsignup
= 1
AND customer type
= 'UWC'
Then Date
- EndDate - Beast mode calculation
- CASE WHEN
countasUWCsignup
= 1
AND customer type
= 'UWC'
Then Date
- UWC is the membership type but I am not getting the correct start or end dates
If I do a filter on the card for using Customer type nd countasUWCsignup =1 I get the correct start date.
Thank you