Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 29, 2021 01:03 PM
Hey Y’all,
Is anyone familiar with Google Data Studio?
Context:
I’m playing with an idea of archiving data from Airtable.
To do that, I’m routinely exporting the JSON output from the API, and appending a CSV in Google Cloud Storage.
I’m using that CSV to create a report in Google Data Studio.
Problem:
I’m at a loss of how to leverage Linked Records in visualizations, which output from the API as an array of Record IDs.
Currently, Data Studio only sees them as strings.
Questions:
Thanks in advance!
Jan 03, 2022 12:43 AM
All the linked records must be duplicated to separate column as formula (as easy as reference the column). By doing that, the data is stored as text.