How can I create a summary report in Stackby that joins the array of aggregation items into a string with a custom separator for better readability ?
You can use the ARRAYJOIN() function in Stackby to achieve this. Let’s say you have a table with a column containing various items, and you want to create a summary report that combines those items into a single string separated by commas. Here’s how you can do it:
Create a new column in your table where you want to display the joined array as a string (e.g., “Summary”).
In the cell of the “Summary” column for the first row, use the ARRAYJOIN() function. Assuming your items are in the “Items” column, and you want to separate them with commas
ARRAYJOIN({Items}, "! ")