SearchKit - Ability to COUNT() without any grouping
When using aggregates in search kit the assumptions about when it is good to offer aggregates is a bit off.
Scenario - contact has a custom field of type money & search has 2 tables - contribution and contact
Here are some things I can't do:
- group by contact ID and then get a SUM of total_amount
- group by contact ID or contribution ID and get a sum of my custom money field
- group by contact ID and also display COUNT for contact id - or display name - this is useful to create a micro widget that gives a count of contacts that meet a criteria & which links to somewhere else.