This is a difficult one as the bucket or bin is based on an aggregation. I was able to get what you were looking for using a couple of table calculations. The "others" bucket doesn't show, but would if there were one or more customers that fell into it.
I've attached a workbook so you can see how I came up with a solution. Feel free to ask if you need any clarification.
Customers in Bucket.twbx.zip 18.5 KB
This is exactly what I wanted.
But the workaround seemed complex to me.
I tried working out on showing the same in graphical view but it didn't happened.
As I want an action filter on this chart to show the details of the customers...
Thanks & Regards,
I agree -- the table calculation solution to this is very complex.
I'm wondering if there is a way to aggregate your data at the source. Where is your data stored? If it is a relational database, then perhaps you can use Custom SQL so you don't have to worry about doing the aggregation calculation. The Custom SQL Statement would look something like this for your data source:
SELECT Customer, SUM([Order Quantity]) AS [Order Quantity]
GROUP BY Customer
Then the calculation for the bucket would be a Row Level calculation and Tableau wouldn't have any trouble counting the customers in the bucket.
Thanks for the workaround.
I am using relational database itself.But the problem here is that in my dashboard I have 4 charts with some global filters etc.Only one of them is the customer wise distribution.Other charts are showing the facts based on different dimensions . I am using a single query for that.So,It will be difficult for me to change the query or add a new connection(because of global filters and all) .
Thats why I am looking for a solution which keeps my whole sheets intact.
Thanks & Regards,