Creating Bins/Histogram Charts on Aggregated Values in Tableau
This documentation is for Kyvos 2026.8.x. To view documentation for other Kyvos versions, click here. |
|---|
1. Overview
Tableau version 9.0 introduced binning values over aggregated data with LOD (Level of Detail) expressions. This page describes how to create a histogram over aggregated values in Tableau using Level of Detail (LOD) expressions and bins. The example demonstrates how to calculate sales by CustomerID, create bins with a specified size, and use the resulting fields to visualize aggregated sales data.
On this Page:
2. Create a Histogram Over Aggregated Values
In this example, we will create a histogram using the sum of sales by CustomerID. Perform the following steps.
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.