Nada Ahmed
08/27/2024, 12:22 PMCeligo AI
08/27/2024, 12:22 PMAI generated answer (using internal Slack threads):To show the items that a transaction includes in a summary saved search on one row, you can use the
NS_CONCAT
function in a formula (text) field. This function is not listed in the function list, but it can be used to concatenate a list of items.
Here is how you can do it:
1. In your saved search, go to the Results tab.
2. Add a new line with the following settings:
- Summary Type: Minimum
- Field: Formula (Text)
- Formula: NS_CONCAT({item})
3. Make sure all other columns in your search are set to a summary type of 'Group'.
This will create a new column in your saved search results that includes a comma-separated list of all items included in each transaction.
Please note that the NS_CONCAT
function will only work if the search is a summary search, and all other fields are set to 'Group' in the summary type.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
08/27/2024, 12:22 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840975881
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.8385005
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.837126553
Celigo AI
08/27/2024, 12:22 PM