Performing Calculations in Tableau Desktop
Performing calculations is one of the most essential parts of analysis in Tableau. Calculations allow you to manipulate your data in ways that standard tools cannot. In this 10-video course learners will explore ways to manipulate various data types with a number of different functions and calculations to solve a wide range of problems. Begin by working with the string functions and using the Calculated Field window and then work with the date functions by using the Calculated Field window. Use quick table calculations to quickly apply common table calculations to visualizations; create simple LOD [level of detail] expressions and use them in visualizations; and observe the use of EXCLUDE and FIXED LOD expressions in calculations. Discover how to perform ad-hoc calculations; configure aggregate and disaggregate options and perform logical calculations. The course concludes by focusing on the use of arithmetic and aggregate calculations and using join calculations to work with data where common fields are missing in the two sources.