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.
New Idea
Min & max functions needed
+5It 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…
- I have data on Company for multiple currency fields representing different ‘buckets’ - Renewal $’s, Upsell $’s, one-time $’s.
- I would like to consolidate the MAXIMUM value from any one of these fields in to a single output field (‘Most $’s’) for all customers
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.
+1+1 to this, this is a must have.
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.