Creating Bins/Histogram Charts on Aggregated Values in Tableau

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.

This documentation is for Kyvos 2026.8.x. To view documentation for other Kyvos versions, click here.

✅ Enterprise: AWS, Azure, GCP, and On-Premises ✅ Marketplace: AWS, Azure, and GCP ✅ SaaS: AWS, Azure, and GCP ✅ Single Node Installation (SNI)

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.


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.

  1. Create a calculated field. Name the calculated field as Sales by CustomerID.

    Example: {FIXED [CustomerID]: SUM ([Sum Sales])}

  2. Right-click Sales by CustomerID in the data pane and select Create > Bins

     

  3. Enter the required bin size in the Create Bins dialog box, as shown in the following figure.

  4. Drag Sales by CustomerID (bin) and SUM (Sum Sales) to visualization area.

     

Copyright Kyvos, Inc. 2026. All rights reserved.