What I'm attempting to do is create a histogram based on a Combined Field (Child + Zip Code, which is our definition of a customer) that shows the distribution of customers depending on their yearly ordering size (1-10 units, 11-50 units, and so on).

Problem: I can't seem to figure out how to appropriately compute the different bins. I've seen a lot of Tableau blogs on utilising bins, but none that computed based on a unique id like mine. If a customer's unit sales exceed the, it seems that they are placed in every category (1-10, 11-20, etc.) rather than a single category. Maybe I'm misinterpreting FIXED LOD calculations.

To show on a histogram, get a count of the consumers in these distinct ordering ranges.

Not having any luck with this formula:

```IF { FIXED [UID_Cust] : SUM([Units]) } <= 10 THEN '1-10'
ELSEIF { FIXED [UID_Cust] : SUM([Units]) } <= 20 THEN '11-20'
ELSEIF { FIXED [UID_Cust] : SUM([Units]) } <= 50 THEN '21-50'
ELSEIF { FIXED [UID_Cust] : SUM([Units]) } <= 250 THEN '51-250'
ELSE '>250'
END```
Mar 25, 2022 in Tableau 319 views

## How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

## How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

+1 vote

## How can I filter data on different sheets based on clicks on Tableau

Filter actions are an essential and fundamental ...READ MORE

+1 vote

## How to join tables based on “Calculated Fields” in Tableau?

You absolutely can join to a calculated ...READ MORE

## Changing filter values based on parameter selection - Tableau

Hi, I will show you an example ...READ MORE

## Fixed Lod to calculate sales from each customer than repetitive orders from customers.

Hi Sindhu, Create a calculated field with below ...READ MORE

## Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

## Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE