Duplicates

B_arnett_1_9_8_8
B_arnett_1_9_8_8 Member
in Charting

Hey guys,

I'm experiencing duplicate fields on my data grid and trying to figure out how to remove them.

Answers

  • MichelleH
    MichelleH Coach

    @B_arnett_1_9_8_8 Where specifically are you seeing duplicates (card, dataset, etc.)?

  • B_arnett_1_9_8_8
    B_arnett_1_9_8_8 Member

    I'm seeing it on my card. I created a table pulling an ID, Name, Child Id, Child Name, and a specific associated tag added. For some reason, almost every line item displays 2 line items (a line of data with and without the tag). It also shows a few lines with the item having previous tags.

    After doing a little more research. it appears that it's almost as if the data is showing all tags that ever were associated to this (past, and present… (currently assigned and no longer assigned)).

  • art_in_sky
    art_in_sky Contributor

    @B_arnett_1_9_8_8 Add a filter to show only lines that have the currently assigned tags ( most recent) to your datagrid.

  • trafalger
    trafalger Coach

    Agreed, the filter is the way to go! Also sometimes adding an aggregate will remove "duplicates!"

  • B_arnett_1_9_8_8
    B_arnett_1_9_8_8 Member

    Thanks, guys, for your help and feedback!

    I'm sorry, I'm fairly new to Domo.

    Are you referring to the traditional filter on the card? Or are you referring to other filters? If so, please elaborate on which filter you're referring to?

  • B_arnett_1_9_8_8
    B_arnett_1_9_8_8 Member

    I don't see many options when editing the traditional filters on the cards

    Screenshot 2025-01-07 145419.png
  • B_arnett_1_9_8_8
    B_arnett_1_9_8_8 Member
    Screenshot 2025-01-07 145515.png
  • ColemenWilson
    ColemenWilson Coach

    You said you had a field with tags. Add that as a filter in the "Filters" section of card analyzer view (the view where you are editing the card). Then filter by Selection on the Tag field and choose the tag that is current.

    If I solved your problem, please select "yes" above

  • art_in_sky
    art_in_sky Contributor

    @B_arnett_1_9_8_8 Is there any date column that distinguishes the tags as empty or most recent, If so, apply the date column as filter and select the most recent date that has the most recent current tag.

    Correct me if I am wrong.

  • B_arnett_1_9_8_8
    B_arnett_1_9_8_8 Member

    There's over 500 selections and not all of them as shown on this view

Categories