Hey folks! I have several boolean fields that I'm trying to aggregate by. Let's say each row represents a customer transaction and each boolean field represents a product that they may have purchased (yes/no).
I want to group by customer and aggregate by the booleans to see how many products each customer purchased across all their transactions.
However, when I aggregate, it seems that none of the aggregators work - I can't use SUM because that returns an error of " 1st operand must be one of these types: int[], decimal[]". Ideally, it would sum the boolean values as 1 or 0s but it's unable to.
Any suggestions on how I can accomplish this?