Sometimes you may have a need for your Looker Studio Table to display an image based on another field in your data. In the image above, I wanted to display a Google Doc icon for all Google Docs and a Google Slides icon for all Google Slides documents. This can be accomplished by using a calculated field derived from a regular expression.
Step 1: Add a calculated field to your data.
Step 2: Name and configure your calculated field.
The image above has the following formula:
IF(REGEXP_MATCH(URL, “.document.“), IMAGE(“https://img.icons8.com/color/48/000000/google-docs–v1.png”),
IMAGE(“https://img.icons8.com/color/48/google-slides.png”))
Basically, I have an existing field called URL in my Looker Studio Table. I know that in that URL string, the word “document” appears, whereas for Google Slides the URL contains the word “presentation”. So wrapping a regular expression inside of an if statement gives us a nice, clean condition. If the url contains document, then display the Google Doc icon, for anything else display the Google Slide icon. Remember to set the data type as an image to ensure your new calculated field returns an image, an not simply text.