Creating bins/histogram charts on aggregated values in Tableau
Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
Kyvos Azure Marketplace  Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos 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.
Â
Copyright Kyvos, Inc. All rights reserved.