How To Make A Bell Curve In Tableau

Welcome to 2020. Hopefully, this will exist the start of a glorious year, and we at Tableau Magic are definitely excited for things to come up. Here is our showtime Tableau Quick Tip on creating a Histogram with a Normal Curve in 10 minutes or less.

Data

We will start by loading the Sample Superstore information into Tableau.

Note: If you have admission to Tableau Desktop and the Sample Superstore data source, please employ that instead.

Calculated Fields

With our data set loaded into Tableau, we are going to create the following Calculated Fields:

Client Count

          COUNTD([Client ID])        

Sales by Customer

          { FIXED [Customer Name]: SUM([Sales]) }        

We are using a LOD expression to go the total amount of Sales by Customer.

Mean

          { AVG([Sales past Client]) }        

We have no dimension as we want the mean to be calculated across the entire information set.

Standard Deviation

          { STDEV([Sales by Customer]) }        

Annotation: I have always wanted to employ the Standard Deviation in a tutorial.

Size of Sales (bin) parameter

Unfortunately, Tableau does not allow you to use out-of-the-box bin in calculations, therefore, we will exist custom building our own Bins; this is simple enough to do.

• Set Proper noun to Size of Sales (bin)
• Fix Data type to Int.
• Set Current value to 500

Sales (bin)

          INT([Sales by Customer] / [Size of Sales (bin)]) * [Size of Sales (bin)]        

Normal Curve

          (     1/MAX([Standard Deviation])*SQRT(ii*PI()) ) * EXP (     -SQUARE(MAX([Sales (bin)]) - MAX([Mean]))     /     (2 * Foursquare(MAX([Standard Difference]))) )        

Notation: This is the Gaussian Distribution Function, besides known every bit the Normal Distribution.

With this done, allow us kickoff creating our data visualisation.

Worksheet

Nosotros will now build our worksheet:

• Alter the Mark Blazon to Bar.
• Drag Sales (bin) onto the Columns Shelf.
  • Correct-click on this pill and convert this to a Dimension.
• Drag Customer Count onto the Rows Shelf.
• Drag Normal Curve onto the Rows Shelf.
  • Change the Mark Blazon to Line.

If all goes well, you should now run across the following:

All nosotros will need to practise now is to work on the cosmetics:

• Dual Axis the pills on the Rows Shelf; do not Synchronize Axis.
• Adapt the colours of your View.
• Hide the Normal Curve Axis.
• Accommodate the tooltip.

You would want to end upwards with something similar the following:

See, squeamish and uncomplicated, please do try to experiment with different Vales (Quantity, Profit etc) and to also adjust the size of the bin to get a smoother line, and with that said, and boom, we are done! I hope y'all enjoyed this tutorial, and as always, you can find this data visualisation on Tableau Public at https://public.tableau.com/profile/toan.hoang#!/vizhome/HistogramwithNormalCurve/HistogramwithNormalCurve

Summary

I hope you all enjoyed this article as much as I enjoyed writing it and as always practise share the love. Practise let me know if you experienced any issues recreating this Visualisation, and every bit always, please get out a comment below or reach out to me on Twitter @Tableau_Magic. Practise besides remember to tag me in your piece of work if y'all use this tutorial.

If you like our work, practise consider supporting united states on Patreon, and for supporting usa, we will requite you early on access to tutorials, exclusive videos, as well as access to current and future courses on Udemy:

• Patreon: https://www.patreon.com/tableaumagic

Likewise, do be sure to check out our various courses:

• Creating Bespoke Data Visualizations (Udemy)
• Introduction to Tableau (Online Teacher-Led)
• Avant-garde Calculations (Online Instructor-Led)
• Creating Bespoke Data Visualizations (Online Instructor-Led)

Source: https://tableau.toanhoang.com/tableau-qt-histogram-with-normal-curve/

Share this post