Solved
Is there a way of creating a BETWEEN feature for Powerlists? I.E. I want BETWEEN X and Y days.
Is there a way of creating a BETWEEN feature for Powerlists? I.E. I want BETWEEN X and Y days.
Best answer by ben
This should be possible by using two date filters, one with greater than your oldest date and the one with less or equal to your soonest date. If you want a rolling window, you could do the same thing but incorporate the "Subtract X days from Rule Date" feature.
Happy to help if you have more specifics!
Happy to help if you have more specifics!
Hey Chris -
Assuming you have a date field (maybe created date) on the Contact object, you could do this with logic on the Powerlist.
Assuming you have a date field (maybe created date) on the Contact object, you could do this with logic on the Powerlist.
This should be possible by using two date filters, one with greater than your oldest date and the one with less or equal to your soonest date. If you want a rolling window, you could do the same thing but incorporate the "Subtract X days from Rule Date" feature.
Happy to help if you have more specifics!
Happy to help if you have more specifics!
-Ben
Ack you beat me Tim! Nice work.
Ha! Great minds. : )
We have a field for Days Until Renewal and want to say Days Until Renewal (under Customer Info) between X and Y and it hasn't worked for us consistently. Would we need to move the field under Contact or Account for us to achieve the above?
Hey Chris -
I would recommend you use Advanced Outreaches (aka Journey Orchestrator). You can build a list of contacts via the Query Builder that allows you to bring in various data sets just like a bionic rule. That way, you could associate those dates on the account and/or contact level.
I would recommend you use Advanced Outreaches (aka Journey Orchestrator). You can build a list of contacts via the Query Builder that allows you to bring in various data sets just like a bionic rule. That way, you could associate those dates on the account and/or contact level.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.