Any calculated field that uses aggregates (like MAX(), MIN(), COUNT(), SUM(), etc…) must have it’s GroupBy box unchecked.
If you need to group by that calculated field, you need to add another subquery layer.
Any calculated field that uses aggregates (like MAX(), MIN(), COUNT(), SUM(), etc…) must have it’s GroupBy box unchecked.
If you need to group by that calculated field, you need to add another subquery layer.