Listagg function or equivalent

pimogo

Trying to do the following calculation so i can have all the available strings in a given column aggregated with a comma delimiter. Basically trying to correctly use the listagg function which appears to be quietly supported by domo, but still having trouble. Has anyone been able to use this function or get around it some other way? Thanks!

 

Scenario:

Column A          |          Listagg(distinct 'Column A')

Car                    |           Car, Boat, Motorcycle

Car                    |           Car, Boat, Motorcycle

Boat                  |           Car, Boat, Motorcycle

Motorcycle        |           Car, Boat, Motorcycle

MarkSnodgrass

Have you considered using the Magic ETL to do this? You could use the Pivot/Uncollapse Columns tile to do this along with a Combine Columns tile.

pimogo

thanks for the response, Mark. In this use case i need this card to be reactive to user interaction. More specifically, i'm trying to pass page filters as pfilters and need a mechanism to pass an aggregated list of values in the event more than one of these is selected on a given page filter.

GrantSmith

GROUP_CONCAT is the MySQL version of LISTAGG

 

group_concat(MyString separator ', ')

 

pimogo

thanks!

doesn't appear like GROUP_CONCAT is recognized as a valid function in beast mode... ?

jaeW_at_Onyx

You cannot Group_Concat in Beast Mode / Analyzer.  You have to do this in SQL or Magic AFAIK