The data sources that you query to tell stories do not always have all the data points that you need. If they did, someone else would have told the story already. Tableau Public's data engine allows you to create new mathematical calculations of varying complexity, from basic multiplication functions to sophisticated aggregations with specific levels of detail that add color, context, and key insights to your data stories.
In this chapter, we will discuss how to develop new insights for users by understanding and implementing different types of calculated fields. We will use several data sources that we have connected to previously, in order to help you understand the following functions:
Creating and editing calculated fields
Types of calculations
Number functions
String functions
Date functions
Type conversions
Aggregate functions
Logic functions
Blending data sources
Throughout this chapter, we will present and discuss error messages that you are likely to encounter. We cannot...