How can I manage one-to-many relationship in Google Looker Studio
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
I 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.
- Extract randomly data according to multiple criteria
- Google Sheets to Calendar - something wrong with the syntax of the date
- Match data based on id between sheets of one googlesheet &extract alphanumeric values in separate column
- Randomizing the contents of a list in Google Sheets
- My function is only copying the first line. I would like it to copy all line within a range. E.g ("I7:I24")
- Ticker symbols supported by googlefinance function
- Pagination error while accessing data using Google Apps Script
- Cannot extract month name, in specified language, from date
- Time trigger .atDate using a cell as a reference
- How do I increment a Google Sheets range via getRange?
- Google Sheets formula to split a cell that contains a null value
- How to Format the Email Body Properly When Creating Gmail Drafts from Google Sheets Data in Google Apps Script?
- Using setvalues() For Scattered Ranges
- How to test type of range parameter in Google Spreadsheet script?
- How do I set the range to change automatically in Google Sheets API?
- Copying data from a sheet to another with conditions
- Arrayformula and Sum in Google sheets
- Export Single Sheet to PDF in Apps Script
- Need Google App Script to show pop up dialog for insert image in cell
- How can I send an email notification if specified keyword is listed in a range?
- This LET formula outputs data in 2 columns. I want to instead output it to 3 columns with a blank column b/w the two data columns
- Google Sheets - Use an array to check the date then display a table
- How can I manage one-to-many relationship in Google Looker Studio
- can i somehow determine which clickable image on my sheet is pressed rn
- Split If not certain word and not first 4 characters
- How to Import XML table Google Sheets
- Calculating derived values
- Is there any way to do a bitwise shift right on a very large number in Google Sheets?
- Reset Column and Row sizes to default
- How to filter filter data after extracted data in Json form