Hey guys,
I have a bunch of rows of data that need to be exported to CSV, that’s simple enough.
The bit that I cannot wrap my head around is how I export groupings.
For example:
Name | Shift | Quantity |
---|---|---|
Ashley Allen | Night Shift | 1 |
Ashley Allen | Day Shift | 1 |
Ashley Allen | Day Shift | 1 |
Ashley Allen | Night Shift | 1 |
Ashley Allen | Night Shift | 1 |
David Jones | Day Shift | 1 |
Kimberly Roberts | Day Shift | 1 |
In this dataset I want to export not the raw list, but the unique Names, then the unique Shifts, then a count of each, like so:
Name | Shift | Quantity |
---|---|---|
Ashley Allen | Night Shift | 3 |
Ashley Allen | Day Shift | 2 |
David Jones | Day Shift | 1 |
Kimberly Roberts | Day Shift | 1 |
I am at a complete loss, Bubble doesn’t expose the fields within a grouping.
Any ideas of a neat and simple solution?