How to Flag/Color Duplicate values?

1BrandonKlein

Hi,

I have a list of contact information; one column is the Contact's Full Name. I am trying to set a rule where both rows are highlighted when two names are identical. Similar to how in Excel conditional formatting will color identical values.

ArborRose

I would try creating a beast mode field to count how many times each name appears. This will help identify duplicates. Something like

COUNT(`Full Name`) OVER (PARTITION BY `Full Name`)

Then set conditional formatting on the Domo card. Create a rule where - if the name count is greater than 1, it will apply a background color to the row.

ArborRose

I would try creating a beast mode field to count how many times each name appears. This will help identify duplicates. Something like

COUNT(`Full Name`) OVER (PARTITION BY `Full Name`)

Then set conditional formatting on the Domo card. Create a rule where - if the name count is greater than 1, it will apply a background color to the row.

1BrandonKlein

Thank you! It worked!