Kevin Quigley - 7 months ago
This would be a great OOB feature. Although there are countless examples, the one I am currently working with relates to rolling up averages on numeric data. I am trying to create a pareto (sort by average), and can see some outliers immediately bubbling up to the top. When I look at detail rows, this is being caused by individual anomolies. If I could filter by record count at the group level (exclude any groups which contain less than 30 records), this would help combat these scenarios without the need for more mature data science techniques and solve for those every day, quick glance needs. I attempted to work around this limitation with a summary-level formula, but alas they cannot be used as filter conditions.