cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Add Listagg/Concatenate/GROUP_CONCAT to Summary platform

I would like to have possibility to create column with all values (might cause issues, I know) from Summary platform. This would allow me to calculate statistics for some group and still see values for specific columns. This column could also be made Multiple Response

 

Example with SQL in JMP:

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");
Query(
	dt,
	"SELECT age, avg(height), GROUP_CONCAT(name, ',') as name FROM 'Big Class'
    group by age"
);

Would most likely require selection for separator and to determine if column should be multiple response. These could maybe be done in same way as Quantiles which have different selector below column list

jthi_0-1638360999465.png