Search Kit: More options on field transformations of a Date Field
Overview
We are trying to replicate the behaviour that the Contribution Summary Report has. We want the Search Kit to be able to group by Month and Year. As in the image below:
Current behaviour
Currently, in v.5.52, you can group by by Month.
But when showing the results it shows just a date instead of showing just the Month.
This happens because in field transformations there is no option of selecting what to show in a Date Field. Currently only Aggregation options are showed, so it is treated as an integer.
Proposed behaviour
In field transformation it should show different options that let you choose what to show. For example, select between Day/Month/Year so that the column is showed as the Contribution Summary Report.