Looker Expression assistance

Screenshot 2023-09-25 133558.png

Hi -- I am new to Looker and am wondering if someone knows of an expression. I need to create a new column based off "Department Name" that takes just the first 3 characters aka the dept number. I tried using "left_text" but not sure that i used correctly seeing that i get an error message that it's either incomplete or an unknown constant. any help would be greatly appreciated.

0 1 221
1 REPLY 1
Top Labels in this Space
Top Solution Authors