SearchKit Feature Request: Show Group By Field with Function as a Select Field
If we create a SearchKit search using Activities and want to group by the Year of the Activity Date (so we can show counts by year), it doesn't seem to allow us to include the group by field with the calculation as a select field.
For example, I have this basic search:
I want that "year" function field to show up in the results. But when I go to Select fields, I can only aggregate on the Activity Date field. I don't see the function-enabled group by field as an option to show.
This is pretty common when building SQL for reporting. We group by a field and show that field in the SELECT.