I’m in the beginning stages of setting up Adoption Explorer. One question I have is how to convert some of my date fields to boolean. Our situation, is that we have easy access the last used date for certain features. We want to use those dates to say if the date is within the last 3 months/6 months/year, then checkbox = true for the customer using that feature.
I thought I’d be able to do this via a Derived Field and Case Function, but for date fields I either have to compare to a specific date or another available date field, there is no option for last year, subtract 90 days, etc. Is there another function type that can get me to the end result I’m looking for? Or do I need to have our data team do this calculation prior to bringing in our data?
Best answer by skalle
View original
