I am creating, what I thought would be a quick, gallery for one of our Departments to get snapshots of some of their lists.
Ideally they would like to be able to see how many items have been submitted to multiple lists within a single display. I started off by creating separate collections for each list that gives the list name, records submitted the last 30 and 90 days.
I know they are going to want more of a breakdown from month to month, so I was wondering how to group records for a CountRows based on the month/year something was created.
Here is a sample collection I would need to expand on:
ClearCollect(colBottleWater,{Title:"Bottled Water",All:CountRows('Bottled Water'),ThirtyDays:CountRows(Filter('Bottled Water',Created>=DateAdd(Today(),-30))),NinetyDays:CountRows(Filter('Bottled Water',Created>=DateAdd(Today(),-90)))});
I have a collection for each list as above, and then compile all the collections into a new collection for the Gallery display.
