Is it possible to display aggregated data from multiple subcollections?
I’m trying to create a dashboard that displays our order data. I would like to show in a line graph the total orders made every month. My order data is stored as followed:
Locations/{location_document}/orders/
I have multiple locations, each have their own order document. Each order document has a subcollection with all orders stored.
When I select a datasource for the line graph, I can select the subcollection, however I have to define the parent path. In this parent path I can only select one document as parent. Is it possible to select all documents as parent path? I tried to work around this with a multiple select dropdown component displaying all the parent (location) documents. However when I select more than one document, the query doesn’t work.
Is there any way to display the sum of all orders from all subcollections?