How can I remove duplicates with a beast mode?

kim_barragan0126 · 2024-10-24T20:49:02+00:00

There was an error rendering this rich post.

I want to remove duplicates from 1 or 2 columns, whichever is the easiest. I prefer the match ID column, or it also could be the Candidate column. I want to count each match ID once per the PPED (period end date.) I want to get a active count of matches on billing each week. If i can't do with a beast mode, I can also try ETL. I tried the below beast mode, but it doesn't work.

COUNT(DISTINCT Match Id)

Find more posts tagged with

Accepted answers

ColemenWilson

To get that output, you don't need to use any beastmodes. You can just create a table card and aggregate (SUM) on TotalBilled

All comments

ColemenWilson

COUNT DISTINCT is the right function. What do you mean it doesn't work? Could you share a bit more?

If you want to remove duplicates in Magic ETL you can do so using the Remove Duplicates tile. https://domo-support.domo.com/s/article/360044876614?language=en_US#remove_duplicates

kim_barragan0126

The COUNT DISTINCT is not removing the duplicates. And if I remove dupes in ETL, i am losing the $ associated to the match ID's. The match ID's show up weekly, and I just want to count then once each week. Maybe I am not able to do so.

ColemenWilson

Count Distinct doesn't "remove" the duplicates, it just ensures they are only counted once. Is this the output you are looking for?

kim_barragan0126

Yes. I will try it again. I appreciate the help!

ColemenWilson

To get that output, you don't need to use any beastmodes. You can just create a table card and aggregate (SUM) on TotalBilled

kim_barragan0126

Thank you. Good point. I also need a way to count how many candidates or matches, and that is why i was using the Distinct Count. Appreciate your help!

ColemenWilson

Okay, were you able to get the count of candidates or do you need help with that as well?

kim_barragan0126

I am all good - thank you for asking!