Capture Duplicates in DOMO

WorldWarHulk · December 2022

Hi DOMO -

Is there a way to do this excel formula in Beastmode?

=COUNTIFS($A$2:$A$8, $A2, $B$2:$B$8, $B2)

basically, it shows the duplicates based out of 2 columns.

what we have is the Name and the Title and the location

we want to see how many names have the same title

for example:

Peter Manager San Francisco

Peter Manager California

Paul Director Florida

Paul Manager Orlando

In the example above, Peter has the same title, so we want to mark Peter as True since he is a manager more than once.

ST_Superman · December 2022

See if either of these works:

sum(count(`Location`) fixed (by `Name`,`Title`))

or

count(count(`Location`)) over (partition by `Name`,`Title`)

MichelleH · December 2022

Hi @WorldWarHulk you could make a beast mode like this to count the same name and title appear in the same row:

COUNT(COUNT(`Location`) FIXED (BY `Name`,`Title`))

WorldWarHulk · December 2022

Thank you for this

but I am just getting all 1's ?

MichelleH · December 2022

@WorldWarHulk Are you including Location as a column in your card?

WorldWarHulk · December 2022

yes I used the formula

COUNT(COUNT(`Location`) FIXED (BY `Name`,`Title`))

ST_Superman · December 2022

See if either of these works:

sum(count(`Location`) fixed (by `Name`,`Title`))

or

count(count(`Location`)) over (partition by `Name`,`Title`)

WorldWarHulk · December 2022

This did it>>>

Thanks!!!

Beast Mode