URL actions in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a URL action that opens a website when a user clicks a mark.

Tableau

URL Action: 'https://www.example.com/' || [1]

Drag options to blanks, or click blank then click option'

A[Category]

BSUM([Sales])

C[ProductID]

D[Region]

Attempts:

3 left

💡 Hint

Common Mistakes

Using aggregated fields like SUM([Sales]) in the URL action.

Using a category or region which may not uniquely identify the item.

The URL action should use a field that uniquely identifies the item, such as ProductID, to direct the user to the correct page.

2fill in blank

medium

Complete the code to encode the URL parameter correctly for spaces.

Tableau

URL Action: 'https://www.example.com/search?query=' || [1]

Drag options to blanks, or click blank then click option'

AREPLACE([Product Name], ' ', '%20')

BLOWER([Product Name])

CUPPER([Product Name])

DLEFT([Product Name], 5)

Attempts:

3 left

💡 Hint

Common Mistakes

Using LOWER or UPPER functions which do not encode spaces.

Using LEFT which truncates the string but does not encode spaces.

Spaces in URLs must be encoded as %20. The REPLACE function substitutes spaces with %20.

3fill in blank

hard

Fix the error in the URL action expression to concatenate base URL and parameter correctly.

Tableau

URL Action: 'https://www.example.com/product=' [1] [ProductID]

Drag options to blanks, or click blank then click option'

A&

B+

C+='

D||

Attempts:

3 left

💡 Hint

Common Mistakes

Using + which is not valid for string concatenation in Tableau.

Using & which is used in some other languages but not Tableau.

In Tableau, string concatenation uses the || operator, not + or &.

4fill in blank

hard

Fill both blanks to create a URL action that opens a Google search for the selected category.

Tableau

URL Action: 'https://www.google.com/search?q=' || [1] || REPLACE([2], ' ', '+')

Drag options to blanks, or click blank then click option'

A[Category]

B[Product Name]

C[Region]

D[Customer]

Attempts:

3 left

💡 Hint

Common Mistakes

Using different fields in the two blanks.

Using fields that are not relevant for the search.

The URL action should use the Category field and replace spaces with '+' for Google search queries.

5fill in blank

hard

Fill all three blanks to build a URL action that opens a map with the selected city and state.

Tableau

URL Action: 'https://maps.example.com/?city=' || [1] || ' &state=' || [2] || REPLACE([3], ' ', '%20')

Drag options to blanks, or click blank then click option'

A[City]

B[State]

D[Country]

Attempts:

3 left

💡 Hint

Common Mistakes

Using Country instead of State.

Not encoding the city name for spaces.

The URL uses City for the city parameter (also encoded for spaces), and State for the state parameter.