I’ve just started looking into data aggregations as opposed to querying and manually doing groupings and math and so far I’ve loved the switch as aggregations are much faster and more efficient. With that said, I need to be able to group by a date field for data analysis. I need to be able to analyse data based on the hour, day of the week, date range, etc. but it looks as though with aggregate groupings there is only grouping by table attributes. Is it possible to do what I’m wanting to do or is the only solution to either manually group, run multiple aggregations, or create attributes for every one of those groupings I need?
Thanks.
Posting again to see if I can get a response. I know it’s possible with SQL code but I’m wondering if wix aggregations has the functionality for it.