Notification

This Help Center is moving to Cloud. Learn more about the migration.

HYPERLINK

Create links from your data.

Use the HYPERLINK function to create clickable text and image links in tables. Report viewers can click these links to navigate to other pages in your report or on the web.

In this article:

Sample usage

Create a link to a product catalog page and display the item name as the anchor text:

HYPERLINK(Item URL, Item Name)

Display an image of a product and link to that item's page in your catalog:

HYPERLINK(Item URL, Item Image)

Syntax

HYPERLINK(URL, anchor_text)

HYPERLINK(URL, image)
  

Parameters

  • URL - A field or an expression that evaluates to the URL data type
  • anchor_text- A field or an expression that evaluates to the Text data type
  • image - A field or an expression that evaluates to the Image data type

How the HYPERLINK function works

The HYPERLINK function has two forms: The first form creates a text link field, and the second form creates an image link field. Text link fields have the Hyperlink data type, while image link fields have the Image Link data type in your data source. You can add these fields to tables in your reports to give users a way to navigate to other pages.

The HYPERLINK function requires two parameters: the first parameter must be a URL. If the second parameter is a Text field or expression, the function creates a Hyperlink field. If the second parameter is an Image field or expression, the function creates an Image Link field.

The URL parameter provides the link target (the href portion of the link). The URL parameter can come from existing URL fields in the data source, or the parameter can be an expression that builds URLs from other fields and functions.

The anchor_text parameter specifies the linked text to display. The anchor_text parameter can be from a Text data type dimension in your data source or any other expression that evaluates to the Text data type.

To create an Image Link field, provide an Image dimension in your data source or any other expression that evaluates to the Image data type in place of the image parameter.

Tip: Use the IMAGE function to create Image fields.

Supported protocols

The HYPERLINK function supports the following protocols:

  • http
  • https
  • mailto
  • ftp

If you specify an unsupported protocol, the link opens a blank page. If you don't specify a protocol, the HYPERLINK function prepends http: to the URL.

Notes

You can't change the data type of Hyperlink fields.

To display a clickable link in a table that displays the full URL as the anchor text, you can also use the URL field type.

Examples

Use HYPERLINK to create a product catalog with pictures of the items that have been sold and links to individual product description pages.

Suppose you have a data set with the following fields:

  • Item - The name of the product
  • SKU - The product identifier
  • Product Page - The URL of the product's description page
  • Product Image - The URL of the picture of the product that you want to display

For example:

Item SKU Product Page Product Image
Pen 123 https://example.com/products/product123.html https://example.com/images/product123.jpg
Notebook 456 https://example.com/products/product456.html https://example.com/images/product456.jpg
Coffee Cup 789 https://example.com/products/product789.html https://example.com/images/product789.jpg

 

Creating a data source from the previous example gives you the following fields:

Field Type
Item Text
SKU Text
Product Page URL
Product Image URL

 

Example 1: Create text links to product pages

To display links to the product description pages, create a Product Link calculated field with this formula:

HYPERLINK(Product Page, SKU )

The data source now looks like this:

Field Type
Item Text
SKU Text
Product Page URL
Product Image URL
Product Link Hyperlink

 

You can then add the Product Link field to a table in your report. This displays the data as clickable links.

Example 2: Build URLs using CONCAT

Building URLs with the CONCAT function is useful when only part of the link path is present in a field or when you want to override or add more information to the link.

For example, you could use CONCAT to combine a hardcoded page path with a product SKU to form a complete URL to your product description page:

HYPERLINK(CONCAT('http://example.com/productpages/product', SKU, '.html'), Item)

Example 3: Create clickable images

To add clickable images to a table, you also use the HYPERLINK function but provide a URL as the first parameter and an Image field, or an IMAGE function with a valid link to an image, as the second parameter. This creates an Image Link field.

In this example, the Product Page dimension holds the URL, and the IMAGE function generates an Image field using a single hard-coded value:

HYPERLINK(Product Page, IMAGE("https://example.com/images/product789.jpg", "Coffee cup")

As a more realistic example, you might either create the Image field ahead of time and store it in your data source or use the CONCAT function to build the image parameter:

HYPERLINK(Product Page, IMAGE(CONCAT("https://example.com/images/"), SKU, ".jpg", Item))

Links and thumbnail images from YouTube

The YouTube Analytics connector automatically provides links and thumbnail image fields you can add directly to tables in your reports:

Field Type Description
Video Link URL The link to the video on YouTube
Thumbnail Link URL The link to the video thumbnail image
Thumbnail Image The thumbnail image
Linked Thumbnail Image Link The thumbnail image formatted as a link to the video on YouTube

Was this helpful?

How can we improve it?
true
What's new in Looker Studio?

Learn about new features and recent changes. Looker Studio release notes live on Google Cloud.

Search
Clear search
Close search
Google apps
Main menu
971560516696497122