Document toolboxDocument toolbox

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.

  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. All rights reserved.