#TABLEAU PREP CALCULATED FIELD HOW TO#

The type of calculation you choose depends on the needs of your analysis and the question you want to answer. For more information, see Transform Values with Table Calculations (Link opens in a new window).

Table calculations - Table calculations allow you to transform values at the level of detail of the visualization only. They can be performed at a more granular level (INCLUDE), a less granular level (EXCLUDE), or an entirely independent level (FIXED) with respect to the granularity of the visualization.įor more information, see Create Level of Detail Expressions in Tableau (Link opens in a new window). However, LOD calculations give you even more control on the level of granularity you want to compute. Level of Detail (LOD) expressions - Just like basic calculations, LOD calculations allow you to compute values at the data source level and the visualization level. There are three main types of calculations you can use to create calculated fields in Tableau:īasic calculations - Basic calculations allow you to transform values or members at the data source level of detail (a row-level calculation) or at the visualization level of detail (an aggregate calculation). You create calculated fields using calculations. To convert the data type of a field, such as converting a string to a date.You can use calculated fields for many, many reasons. But don't worry: your original data remains untouched. This new calculated field is saved to your data source in Tableau, and can be used to create more robust visualizations. When you create a calculated field, you are essentially creating a new field (or column) in your data source, the values or members of which are determined by a calculation that you control. Why Use Calculated FieldsĬalculated fields allow you to create new data from data that already exists in your data source. If you're new to Tableau calculations or to creating calculated fields in Tableau, this is a good place to start.

#TABLEAU PREP CALCULATED FIELD HOW TO#

You will also learn how to work with the calculation editor, and use a calculated field in the view. You'll learn Tableau calculation concepts, as well as how to create and edit a calculated field. This article describes how to create and use calculated fields in Tableau using an example.

Tableau prep calculated field