Search Kit: Unable to Aggregate on a Custom Field
I am trying to create Form based on Search kit that will Sum up the value of a custom field. The custom filed is an activity custom filed of type 'number' When I group by contact ID and go to field transformation I do not get any aggregate options. Sum is not available. I do get a math option, but none of the options will work for the use case. Any thoughts? This issue is on all version 5.45+
Would like to see?
When transforming I only see:
I tried number and integer type on the custom field and same results.
tested on 5.45.x, 5.46.x, 5.47.3