Type conversion functions in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the INT() function do in Tableau?

The INT() function converts a value to an integer by removing any decimal part. For example, INT(3.7) returns 3.

beginner

How do you convert a string to a date in Tableau?

Use the DATE() function to convert a string that represents a date into a date data type. For example, DATE('2024-06-01') returns a date value.

beginner

What is the purpose of the STR() function in Tableau?

STR() converts a number or date into a string. For example, STR(2024) returns "2024" as text.

intermediate

Explain the FLOAT() function in Tableau.

FLOAT() converts a value to a floating-point number (decimal). For example, FLOAT('3.14') returns 3.14 as a number.

intermediate

What happens if you try to convert a non-date string with DATE() in Tableau?

Tableau returns a NULL value if the string cannot be converted to a valid date.

Which Tableau function converts a number to a string?

A STR()

B INT()

C DATE()

D FLOAT()

STR() converts numbers or dates into text strings.

What does INT(5.99) return in Tableau?

A 5

B 6

C 5.99

D NULL

INT() removes the decimal part, so INT(5.99) returns 5.

Which function converts a string like '2024-06-01' to a date?

A FLOAT()

B INT()

C DATE()

D STR()

DATE() converts a string to a date data type.

What will FLOAT('3.14') return?

A NULL

B 3

C '3.14'

D 3.14

FLOAT() converts the string to a decimal number 3.14.

If DATE('hello') is used, what does Tableau return?

A Current date

B NULL

C 'hello'

D Error message

Invalid date strings return NULL in Tableau.

Describe how to convert a number to a string and a string to a date in Tableau.

Think about functions that change data types from number to text and text to date.

What happens when you use INT() on a decimal number and when DATE() receives an invalid string?

Consider how Tableau handles type conversion errors or rounding.