Tableau 10 Complete Reference

Row Level examples

Consider the Apartment Rental data source. Let's say the naming convention of the apartment actually has the building and the unit number; for example, the apartment named A-2 is unit 2 in building A.

In the Chapter 03 workbook, create a couple of calculated fields. Name the first building with the following code:

SPLIT([Apartment], "-", 1) 

Then create another calculated field named Unit with the following code:

SPLIT([Apartment], "-", 2) 

Both of these functions use the Split() function, which splits a string into multiple values and keeps one based on a delimiter and a token number. The function takes three arguments: the string, the delimiter (value separator), and the token number (which value to keep from the split: ...