I have a Google Sheet which I use as datasource for Looker Studio. The sheet basically is a list of projects and some metrics, with the number of partners for each project. The info could be summarized as follow:
| Project ID | Partner ID |
|---|---|
| 1 | 1 |
| 1 | 2 |
| 2 | 1 |
| 2 | 3 |
I have a Google Sheet which I use as datasource for Looker Studio. The sheet basically is a list of projects and some metrics, with the number of partners for each project. The info could be summarized as follow:
| Project ID | Partner ID |
|---|---|
| 1 | 1 |
| 1 | 2 |
| 2 | 1 |
| 2 | 3 |
| Proj ID | Budget |
|---|---|
| 1 | 100k |
| 2 | 200k |
| 3 | 500k |
Is there a way to represent a one-to-many relationship in google looker?
More specifically I would like to map the location of the Partners on a map chart and the total budget into an indicator. If I use the blend feature, it doesn't show up with correct numbers (for example it sum the project budget for each number of partner). Is there any reference online where I can get more info?
Thanks
Share Improve this question asked Feb 6 at 0:28 Giuseppe CavalloGiuseppe Cavallo 111 bronze badge1 Answer
Reset to default 0I have a work around so you do not have to create a relationship.
If you just want to be able to select a project on a dropdown and see the budget and the partners ID, I would just link the tables by a combined field name and use a slicer.
If you have a field with an identical name and data type, Looker should link the 2 together automatically so that if you add a slicer to one it will filter the other table as well.
If the fields do not automatically join you can create a calculated field in each data table that references the ID you want to use and name the field IDs with exactly the same name.