Highlight Duplicate

Reply
Visitor

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. 

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

Announcements
Domopalooza 2018! Pre-conference training registration is now open! Click here!