Highlight Duplicate

White Belt

Highlight Duplicate

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. 

Red Belt

Re: Highlight Duplicate

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
Call for Presenters! We want to hear your Domo story, submit your entry and win a free pass to Domopalooza 2019!. Click here!