Question related to Saved search: If having a reco...
# suiteanalytics
j
Question related to Saved search: If having a record with multiple sub-records (with for example different start-dates for the different sub-records) and I want to get a result in a Search showing information for my record with sub-record information for only the sub-record with the maximum start date. How can this be done? Any ideas?
n
Use the Order By Assuming Start Date ,Group By, Maximum Main Record Field 1, Group By, Maximum, Order By, Start Date Main Record Field 2, Group By, Maximum, Order By, Start Date
👍 1
j
Wow. That looks to be working just as I wanted it. Was not aware of the "When ordered by filed" function. Thanks a LOT for very good input!!!!