Beastmode listagg/group concat

Hello,

I usually refer to the list of magic etl functions documentation for functions that I can potentially use in beastmode since some working functions do not exist in the list within the beast mode editor.

However, a function that can combine strings from multiple rows into a single string like GROUP_CONCAT and LISTAGG does not work in beast mode. Is there any alternative to this?

By the way, the reason I don't do it in the ETL or SQL is because I want the output to be responsive to card filters.

Here's a particular use case, if I have a dataset with the fields: accounts, end users, date, and products, and I want to see all the products the accounts have sold to their unique end users in comma-separated values, and I want it to be responsive to filters. Say, if I filter only for the last 12 months, and the concatenated products should only show all the products sold in the last 12 months without duplicating the accounts by end user rows.

Thanks in advance