Concat and count

Ken86 — Tue, 25 Jan 2022 11:52:46 GMT

Hi!

My data is looking something like this (with alot more ID's and colors):

I created a table and added =CONCAT({<category=>} DISTINCT category, ', '). And it looks something like this:

customer_ID	=CONCAT({<category=>} DISTINCT category, ', ')
1	blue, red
2	blue, red
3	blue, red, yellow
4	blue, red, yellow
5	yellow
6	blue

My next step, which I can't figure out. Is to create a new table with the this as end result:

Number of cumster_ID's that has the same categories.

Pls help

Best regards,
Ken

Re: Concat and count

hic — Tue, 25 Jan 2022 12:41:00 GMT

Use

=Aggr(CONCAT({<category=>} DISTINCT category, ', ', category), customer_ID)

as dimension, and

=Count(distinct customer_ID)

as measure

Ken86 — Wed, 26 Jan 2022 06:46:06 GMT

Works like a charm, thank you!!!