Huge need to be able to have Min/Max functions across multiple fields. Have run into massive pains getting down to a single value across multiple fields in Rules/DD, and have hit limitations in case statements that have created dozens of hours on workarounds.
Min & max functions needed
CS Rules & Permissions
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.
It sounds like the core ask here is to be able to apply a Field vs Field filter to >2 fields at once, which I think is reasonable. Consider the following use-case…
Currently, I’d need to run a series of tasks to pre-aggregate the data and then methodically pare it down with a series of Field=Field filters in Case statements. The number of tasks required for this grows quickly when you add a 4th/5th/6th field etc.
A specific function to pick min/max from any of several input fields, and output it as a single field, would save a lot of admin work and extraneous tasks cluttering up the rule. This would also make it MUCH less likely that I’ll run out of Cases or tasks in the course of building.