Hello @Joe_C, I wanted to check in and see if you found the solution to this problem. I believe that last comment you made should resolve the mismatch aggregation issue. If you utilized min, max, or median for the unaggregated field and then compared it with the stdev field you should be able to filter through the ifelse statement. If you utilized a different work-around or have any other questions to resolve this, please let me know!
Hey Dylan, using min/max ended up working for me, but in the process I also discovered that I needed to be using avgOver() and stdevOver() in my ‘3 Sigma’ calc fields, and in my ifelse() for the ‘outlier_tag’, I needed to use 'minOver(), while specifying a group field (2nd arg using brackets ‘[ ]’) unique to each row in the dataset.
Thank you for following up!
1 Like