Forum Discussion

sy898661's avatar
sy898661
Helper V
8 years ago
Solved

Show duplicate entries?

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!

Need Help
  • MFelix's avatar
    MFelix
    8 years ago
    You must add a column without summarization and another with count.

    Regards,
    MFelix

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    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's avatar
      sy898661
      Helper V
      8 years ago

      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's avatar
        MFelix
        Super User
        8 years ago
        You must add a column without summarization and another with count.

        Regards,
        MFelix