Airtable - pull labels from primary field instead of record ID?

Hi folks,

New user here. I'm trying to create a dashboard for data collected in Airtable, and I can't seem to get Looker to label the data using the primary field; it gives me the record ID's instead, which renders the charts un-readable.

Example:

Screenshot 2025-01-17 095159.png

Those record ID's should be the names of platforms where we advertise: Craigslist, Google, etc.
 
Any help configuring the chart properties so the labels are readable would be appreciated.
 
Thank you,
 
Shawn
Solved Solved
0 2 96
1 ACCEPTED SOLUTION

That looks more complicated than the solution I used, which was to simply add a name column to the table and use that for the label.

 

View solution in original post

2 REPLIES 2

If the field you need to display is misisng in the schema consider using Case formula.

https://support.google.com/looker-studio/answer/10471275?hl=en#zippy=%2Cin-this-article

Regards
Arkady

That looks more complicated than the solution I used, which was to simply add a name column to the table and use that for the label.