I am trying to archive this Opp end result in the data designer. If any one has done this before or can solve this would be helpful!
If so, this can be done using two fetches, as you’ve shown, and then using a MERGE that has a merge on a field that is common to all records, which will allow the data from the second fetch (with the MIN and MAX values) to be appended to all records from the first fetch.
used this solution to achieve what I wanted to.
Reply
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.