Posted by John David Sant
November 27, 2019
This Master Challenge focuses on the following situation: A client currently has a view that shows the profit and sales figures for every customer. There is a parameter that allows the user to toggle between all the data points and only those data points that are not outliers. In this case, an outlier is defined to be any customer that has a profit value that is three standard deviations away from the median profit per customer. These are values that are exceptionally low or high. By looking at the number of marks in the bottom left corner, we can see that we have 793 total customers. When we select to hide the outlier customers, this leaves us with 780 customers which indicates that 13 customers are being classified as “outliers”. The client would like to add a reference line to show the average profit per customer. The value of the reference line should not change when the user toggles between showing and not showing outlier customers.
You can get started with the challenge by downloading the workbook here.
Give it a try and check your results against our solution here.
Explore Posts By Category
Recent PostsThree Table Calculation Functions for Tableau that Should be on Your Radar What to Ask Before Embedding Analytics with Tableau 7 Most Impactful Business Intelligence Trends for 2020 More than a Business Intelligence Maturity Model Tableau Master Challenge #6 - Reference Lines and the Order of Operations
Ask us for a complimentary consultation - just leave your email!