I’ve been scouting the forums and guides as we have set up Metabase for our product in the last few weeks.
What we currently have is a SaaS product, that has a small, independent instance of our product for all of our customers. Let’s use an example to try to explain what I’m getting at:
instance 1 - customer 1
instance 2 - customer 1
instance 3 - customer 1
instance 4 - customer 2
Every instance is connected to Metabase and we have a set of reports and dashboards that we manage to copy via a script from our template collection. Then by using groups and permissions we give access to the collection related with the customer instance.
So Bob (customer 1) can see 3 collections of reports for his 3 instances (instances 1, 2, 3)
In the same time Mary (customer 2) can only see her collection for instance 4.
This works just fine and the customers see reports for their individual instances. What we’re struggling to find a solution for is how to use the same template collection and use it to display an aggregated report for all instances owned by one customer. In my example above, Bob has 3 instances and would like to see an accumulated report for all 3 instances at the same time (for example: all new transactions within his 3 instances, now he can only see that separately).
Is this possible to achieve within Metabase? Or do we have to create another db and aggregate the data there?