Hi Guys,
I want to concat and show all the sales t...
# suiteanalyticsn
Nilesh Patil
03/10/2021, 12:56 PMHi Guys,
I want to concat and show all the sales team members in one column(like if there are 3 people in sales team of an Opportunity then I want to show all three names in one row only) in a saved search!
How can I achieve it! kindly let me know!!
g
George McMullen
03/10/2021, 3:05 PMTry `NS_CONCAT(,field}`a formula text
George McMullen
03/10/2021, 3:07 PMHmm.. my answer didn’t go through properly,
George McMullen
03/10/2021, 3:07 PMNS_CONCAT({field}, ', ')George McMullen
03/10/2021, 3:07 PMUse Min summary type
George McMullen
03/10/2021, 3:14 PMSorry, function is:
NS_CONCAT({field})m
michoel
03/10/2021, 7:46 PMIf you want control of the delimiter use
LISTAGGn
Nilesh Patil
03/11/2021, 5:31 AMHi, This column is not adding anything in the result
I can't even see the column !
m
michoel
03/11/2021, 5:31 AMIs it a grouped search?
n
Nilesh Patil
03/11/2021, 5:31 AMnop
m
michoel
03/11/2021, 5:31 AMIt will need to be
n
Nilesh Patil
03/11/2021, 5:32 AMI have to group all the columns?
Nilesh Patil
03/11/2021, 5:35 AMthis is how my search results looks like
Nilesh Patil
03/11/2021, 5:36 AMI tried grouping first two results but it is throwing error : something went wrong!
m
michoel
03/11/2021, 5:38 AMGroup by document number and add summary columns such as min/max to any other columns you want to show without drilling down
n
Nilesh Patil
03/11/2021, 5:49 AMokay cool, thanks!