Creating bins/histogram charts on aggregated values in Tableau

✅ Enterprise: AWS, Azure, GCP, and On-Premises

✅ Marketplace: AWS, Azure, and GCP

✅ SaaS: AWS, Azure, and GCP

✅ Single Node Installation (SNI)

Tableau version 9.0 introduced binning values over aggregated data with LOD (Level of Detail) expressions.

To create a histogram over aggregated values:

Assume: Create a histogram using the sum of sales by CustomerID.

Create a calculated field. Name the calculated field as Sales by CustomerID.
^{Example: {FIXED [CustomerID]: SUM ([Sum Sales])}}
Right-click Sales by CustomerID in the data pane and select Create > Bins
Enter the required bin size in the Create Bins dialog box, as shown in the following figure.
Drag Sales by CustomerID (bin) and SUM (Sum Sales) to visualization area.