Can I nest a Select Distinct function in a beastmode?

user145673

Relatively new to all of this, but I'm working on a beastmode that calculates the average tenure of active employees within my company. The data I'm pulling from includes a lot of duplicate system id's (employee id's). I need to filter out these duplicates in order to get an accurate average. I've written the formula in a myriad of ways--it was valid until I added the select distinct 'system id' syntax. Am I missing something, or is there a workaround I'm not aware of? Thanks for your help.

MarkSnodgrass

I would suggest using Magic ETL to clean your data. You can use the Remove Duplicates tile to remove duplicates very easily. Here's the KB article:

https://domohelp.domo.com/hc/en-us/articles/360044876614-New-Magic-ETL-Tiles-Filter#4.

within a beast mode, you do have options like COUNT(DISTINCT fieldname) that may help you, but it depends what else you are doing in your card.