Within my companies services business, we often have customer sites that have multiple services contracts at once. Each of these contracts can have its own contract category and product family tied to them. When working with the Rules Engine I was trying to aggregate data at the site level to gain a representation of overall site usage against the contracts that they have.





With multiple rows attributing to one site, I attempted to group by customer site but ran into an issue with summarizing the different string fields. The current aggregation functionality for String is 'Count', 'Count Distinct', 'Min', Max'. I think it would be valuable to be able to aggregate string field by concatenating them together into a longer string. I would then be able to utilize the 'Contains' filter functionality to apply further logic within the rule.





Summary: The ability to concatenate string fields when aggregating data would be very helpful.