I think it would be great if we could apply more than just 1 level of grouping to a table/list but more importantly support to group by formulas and date fields would be really useful!
For example I am tracking time spent on projects and it would be great to group the time entries by the month and see the total time spent each month.
And to use the same example for the multiple levels of grouping, I could group by year, month, week to get even more granular summaries on the timesheets.
Of course I assume this information could be obtained via reports/charts but I am on the free plan at the moment and I imagine there would be a lot of use cases for these features.
I’d also like multi-level grouping. For our task database, it would look nice if we could group by the state field and then also group by our Parent task (recursive) relation. It would look more organized then what we’re doing now: group by parent task and then sorting by state.
The deep hierarchies work fine if you have relationships, but there are instances where you may wish to group entities by multiple fields that aren’t from a relationship, e.g. grouping tasks by priority and then status
Overall, MrLY explains everything correctly. If the entities have direct relations, then yes – the grouping works to any desired depth. However, if they are connected through formulas or lookups, this functionality is lost because there’s no relationship tree.
Currently, I’m directly linking everything, using auto-linking, which requires me to implement workarounds.
For example, initially, it was like this: Order gets Client from Project via Lookup – nested grouping was not possible.
Now, I do it this way: Order gets Client’s Public ID from Project to Client PID field. Order is auto-linked to Client using the Client PID field.
