Using Calculations: Working with Strings, Dates, and Type Conversion Functions

Question 1

What is string data and what are some examples of it?

Answer 1

Any data that is text - things like names of people, places, or objects

Question 2

What is concatenating in Tableau?

Answer 2

Adding strings together

Question 3

What does a concatenation calculation look like in Tableau?

Answer 3

Connect field names with a + and add any separating characters or fixed strings within double quotations

Question 4

How do you add a non-string field to a concatenated string calculated field?

Answer 4

Enclose the non-string field in STR() within the calculated field

Question 5

What function do you use to calculate the difference between two dates?

Answer 5

DATEDIFF