12.8. Quiz

Multiple-choice Questions

1. Which function can be used to create a hyperlink in Looker Studio?

a. LINK() b. HYPERLINK() c. CONCAT() d. URL()

Answer: b

2. What is the purpose of the CONCAT() function?

a. Combine multiple text strings into a single text string b. Create a hyperlink c. Calculate the sum of two numbers d. Extract a portion of a text string

Answer: a

3. What can a text-based parameter be set to accept?

a. Any value b. A list of values c. Both a and b d. Neither a nor b

Answer: c

4. When is user input for a text-based parameter finalized?

a. When the user presses Enter b. When the user clicks outside the input box c. When the user types the last character d. When the user saves the report

Answer: b

True/False Questions

1. You can create a dropdown control using a text-based parameter with a list of values.

Answer: True

2. The CONCAT() function can be used to create a hyperlink by itself.

Answer: False

3. A text-based parameter can be used to generate dynamic links for various use cases.

Answer: True

Fill-in-the-blanks

1. The data type for a text-based parameter is ______.

Answer: text

2. The function used to create a Google Maps link with a text-based parameter in Looker Studio is ______().

Answer: HYPERLINK

Open-ended Long Answer Question

1. Your company wants to create a Looker Studio report that generates dynamic URLs for specific product pages based on user input. Describe the process you would follow to create a text-based parameter for the product name and generate the URL using the HYPERLINK() and CONCAT() functions. Provide a formula for the hyperlink calculation.

Example answer:

1. Create a text-based parameter called "product_name" with the following configuration:
• Name: product_name
• Type: text
• Default value: Enter the product name
2. Use the HYPERLINK() function to create a hyperlink based on the user input for the product name.
3. Use the CONCAT() function to combine the base URL of the product pages with the user input.
4. The formula for the hyperlink calculation would be:

HYPERLINK(CONCAT("<https://www.example.com/products/>", [product_name]), "Product Page Link")