Showing people in group numbers

[Anonymous]

Hi there,

I need some assistance with how to show the amount of people in lists.

For example I want to display the number of people who belong to multiple lists.

The goal would be to see the people who are highly engaged in the product and belong to multiple lists.

I wasn't sure if this was a Aggr function or creating a summary table in the load.

Thanks!

Desired outcome:

people	lists
2	3
2	2
1	1

using a similar table:

people	list
john	A
john	B
john	C
jill	A
ted	B
ted	C
mike	C
jen	A
jen	B
jen	C

[aarkay29]

PFA

[flipside · Accepted solution]

It might be possible to do this in a straight table.

Create a calculated dimension: =aggr(count (distinct list), people)

Create an expression: =count(aggr(count(distinct list),people))

flipside

[Anonymous]

Thanks this worked great and was very accurate.