Home > 

Advanced Analysis > Calculations

Calculations

To extract meaningful results from your data, you might want to perform one or more calculations. Some calculations are predefined in Tableau, while you can customize others to suit your specific needs.

You can use all of the different types of calculations simultaneously. For example, you can create a new calculated field called Profit that is the difference between the Sales and Cost fields. You could then apply an aggregation (like a summation) to this new field in order to view total profit over time. You could then display the numbers as percentages and turn on grand totals to see how these percentages vary from category to category. Finally, you could bin the new field and display the data as a histogram.

You can use all of the following calculations if you are using a relational data source, however, multidimensional data sources do not support aggregations and binned data.

Aggregations

Calculated Fields

Table Calculations

Binned Data

Totals

Percentages