Date filters in Rules Engine
None
It would be nice to have a date filter with in the rules engine that will enable me to filter like the filters in the report builder. ie current year, last year and this year etc to compliment the ones that are already there. I am trying to set up a CTA but only for data emantaing from a Current Quarter
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Are you running this rule on periodic basis (like daily / weekly) ? or is it a one time rule ?
Since its runnin daily, would it work if you brought in only recent data...ex: You want to create an CTA when a opportunity is closed....the rule will run daily, bring in oportunities closed yesterday & create a CTA.
Would that work for you in the meanwhile?
We need this for a different use case….we’re calculating the % of accounts a CSM has connected with (logged a timeline entry for) in the last year, quarter, month. We’ve created check boxes on the Company object and populate them via a rule if they meet the criteria so all customers are included, even (and most importantly) those with 0 activity records. Currently, we have to manually update our rules to say look at activities after Jan 1 2020, etc. It’s a manual update each time. YTD/QTD/MTD options would allow us to run this as a truly ‘automatic’ rule.
+1!
I’m currently trying to wrap my head around how to have a “last quarter” account-level CSAT calculation in Rules Engine but doesn’t seem to be possible?
Hi all,
Will consider making all the date literals in filters more consistent across the product in the medium-term horizon. We will share any updates here as we drive this forward.
Hi all,
Will consider making all the date literals in filters more consistent across the product in the medium-term horizon. We will share any updates here as we drive this forward.
Thank you! Ran into this issue again (needing previous quarter filter in Rules Engine). Updates/ETA is always appreciated :)
Hi@rakesh ,
I have the same need here, wanting to create a rule that looks at activity in the current quarter. Would be awesome to have the same date filter possibilities as in the Report Builder.
Has there been any progress on this topic?
Thank you for the update!
This is not a near term change Gareth but we definitely are progressing in that direction. One of the enhancement we are doing is expanding date comparison operators.
This screenshot is from Data Designer (upcoming release).
Changing the status accordingly.
https://community.gainsight.com/ideas/current-quarter-and-last-quarter-calculation-in-rules-engine-43160