I apologize if I’m missing how to do this but I have a date field and would like to group items by the date fields month or year. Currently I can only group by the specific date.
If I create a formulas using MONTH or YEAR based on the date I cannot use these to group by.
I would like to see all items listed grouped under Jan/feb/March etc and also be able to group by year- 2019, 2020, 2021 etc. Currently I have to create separately label attributes and assign a date and then “month” and “year” separately to be able to group items.