Now that we know all about Tableau's analytical tools, let's see whether we can solve this sample exam question:
Which subcategories in the LATAM market are more than a standard deviation away from the mean for both sales and profit?
We can answer this question in two ways.
First, we can go with the previous chapter and use INCLUDE statements to show the average and standard deviation of the sum of the two measures. Here, we will define {INCLUDE [Sub-Category]: SUM([Profit])} and {INCLUDE [Sub-Category]: SUM([Sales])} and look at the average and standard deviation of each, as follows:
By performing some simple additions, we can get the lower and upper bounds (for example, $13,038 + $14,161 = $27,199 as the upper bound for profit and $127,330-$111,886 = $15,444 as the lower bound for sales). Subsequently, we can plot Sales and Profit by Sub-category...
