Highlight Duplicate

user02271
user02271
in Dataflows

What can I do in Beast Mode to highlight column cells in a DOMO table that are duplicate values in the same column? For example the cell has a value of 98 and later on down the table the same 98 value appears. I would like DOMO to highlight both cells. 

Comments

  • ST_-Superman-_
    ST_-Superman-_ 🟤

    I don’t believe this is possible in a beast mode. You could try this in an ETL by first sorting by the target field, then creating a rank column, grouped by the target field. Last, you would want to create a windowed function where you take the max of the rank column, partitioned over the target field. 

     

    You could then then write a color rule for any value appearing with a max rank > 1. Or, make a separate color rule when max rank is 2,3,4,etc.


    ______________________________________________________________________________________________
    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
    ______________________________________________________________________________________________

Categories