How to Flag/Color Duplicate values?

1BrandonKlein
1BrandonKlein Member
in Charting

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.

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • 1BrandonKlein
    1BrandonKlein Member

    Thank you! It worked!

Categories