Last week, we discussed in the class of how to simplify complex visualizations in Tableau by creating new data from existing data through calculated fields.<\/p>\n
Though it is best to prepare our data as much as possible before it gets to Tableau, there are many reasons to leverage the calculated fields functionality in Tableau.\u00a0Few of them are:<\/p>\n
As we know it is important to understand the data before making any visualizations. Understanding the data also includes knowing the nature of the data based on which\u00a0we can decide in which family of calculation our data belong. There are three major families of calculated fields in Tableau:<\/p>\n
Non-aggregate calculations\u00a0<\/strong><\/p>\n These are the simplest type of calculation. Non-aggregate calculations are performed for each row in the underlying data, rather than being performed on aggregated data (such as you would find in a pivot table or Tableau view).<\/p>\n It is a\u00a0calculated field which does not use any functions from the \u2018Aggregation\u2019 function group. For example: [Sales] \u2013 [Cost] would be a non-aggregated calculation.<\/p>\n Aggregate calculations<\/strong><\/p>\n Aggregate calculations are those that use aggregate functions.\u00a0 Examples of aggregate functions are SUM, AVG, MAX & MIN (there are a few others). Therefore an example of an aggregate calculation would be: Profit Ratio =\u00a0SUM(Profit) \/ SUM(Sales).<\/strong><\/p>\n When we drag and drop a measure in Tableau, it is automatically aggregated. The default is sum. The primary difference between aggregate and non-aggregate calculations is that aggregate calculations often can\u2019t be sensibly calculated for each row in the underlying data set \u2013 it normally only makes sense to calculate them when the data is aggregated.<\/p>\n Table calculations:<\/strong><\/p>\n Table calculations\u00a0allows us to compare two or more separate measures in our data set,\u00a0it\u00a0allows us to compare a singular measure to itself (the only way to compare a measure against itself). \u00a0These are the calculations which are applied to the values in the entire table. For example, for calculating a running total or running average we need to apply a single method of calculation to an entire column. Such calculations cannot be performed on some selected rows.<\/p>\n When writing any calculation, make sure to know exactly what you want to do. There are many functions and table calculations within the powerhouse of Tableau which can be utilized to create the calculated fields for\u00a0presentation of data in a pictorial or graphical format. Keep exploring. Keep learning.<\/p>\n Sources:<\/p>\n http:\/\/www.clearlyandsimply.com\/clearly_and_simply\/2010\/10\/calculated-fields-in-tableau.html<\/p>\n https:\/\/www.tableau.com\/about\/blog\/2017\/2\/top-10-tableau-table-calculations-65417<\/p>\n Tableau Fundamentals: An Introduction to Calculated Fields<\/a><\/p><\/blockquote>\n