Challenge - Show people names that appear more then once in a table

[coleturegroup]

I have a list of over 1 million names and addresses, i need to show all names with different addresses. Use case: who owns multiple homes?

What does that script look like and what is the best visual to show that?

Thanks team

[sunny_talwar · Accepted solution]

May be add Name as the dimension and the following expression

Count(DISTINCT {<Name = {"=Count(DISTINCT Address) > 1"}>} Address)

[coleturegroup]

Awesome Thanks