Highlight Duplicate


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. 

Blue 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.

Domopalooza 2018! Win 4 nights of free lodging, share your Domo story in Dojo! Click here for more details!