Show duplicate entries?

[sy898661]

Hello!

I have a list of lot numbers (in a table with other data) and I wanted to make a table visual that calls out the ones that have duplicate entries. Is there a way in New Measures or anything else that will return a list of duplicate entries???

I'm sorry if that was confusing, but please help!!

Thank you!

[MFelix]

Hi @sy898661,

Add a table visual and then select the columns that you want to highlith the duplicates and on the summarization select count then just order your table by that counted column.

Regards,

MFelix

[sy898661]

Hi @MFelix,

Can you expand on that a little bit? I have created a table visual that contains the column in which there is repeated data, when I change it to Count it just shows how many data entries there are in total.

Thanks!!

[MFelix · Accepted solution]

You must add a column without summarization and another with count.

Regards,
MFelix

[sy898661]

Got it, thank you!!