Monday of week three started at pace: 3.5 hours deep-diving into calculations and functions in Tableau; a proper wake-up call after the weekend.
For this session, I focused on string functions, which are fundamental for cleaning and preparing data within Tableau. These functions allow you to reshape and standardise text fields, making datasets far more usable for analysis.
Below, I’ve broken down 8 key string functions from the session, using Tableau’s Sample Superstore dataset to keep the examples simple and practical:
- CONTAINS
Calculation:
Output:
- ENDSWITH
Calculation:
Output:
- FIND
Calculation:
Output:
- FINDNTH
Calculation:
Output:
- LEFT/RIGHT
Calculation:
Output:
- LOWER
Calculation:
Output:
- PROPER
Calculation:
Output:
- MID
Calculation:
Output:
Key takeaway:
String functions are a core part of data preparation in Tableau. Small transformations can significantly improve data quality and make analysis more reliable further down the line.