Tableau - Bins based on Fixed LOD Customer Units

0 votes

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 in Tableau by Neha
• 8,940 points
107 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Tableau

0 votes
1 answer

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

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

answered Mar 27, 2018 in Tableau by Atul
• 10,230 points
8,389 views
0 votes
1 answer

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

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

answered Apr 9, 2018 in Tableau by xyz
• 1,560 points
16,188 views
+1 vote
1 answer

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

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

answered Jul 20, 2018 in Tableau by ffdfd
• 5,550 points
8,258 views
+1 vote
2 answers

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

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

answered May 30, 2019 in Tableau by anonymous
19,670 views
0 votes
1 answer

Changing filter values based on parameter selection - Tableau

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

answered Apr 4, 2019 in Tableau by Cherukuri
• 33,050 points
22,275 views
0 votes
1 answer

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

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

answered Apr 30, 2019 in Tableau by Cherukuri
• 33,050 points
710 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

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

Feb 28 in Tableau by Vaani
• 7,020 points
120 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

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

Feb 28 in Tableau by Vaani
• 7,020 points
116 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
116 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
161 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP