7 Replies Latest reply on Jul 3, 2014 9:29 PM by Karthik Venkatraman

# Need help for Top 10 Customers

HI,

I am learning tableau and I came across one question. I am creating a visualization to show top 10 regions based on the sold count of a product. I use two data namely region and product. There will be five products and the regions will sell these products. So I have to show the total count of the products sold in region based on top 10.

The top 10 must be in a way that, I will have a slider that will start from count 10 till 50 moving in a step of 10. So it will be 10, 20, 30 , 40 and 50. When I move the slider the viz needs to show the top regions based on the count. I have created this and when I move the slider I am able to show values based on the slider parameter. When I move the slider to 20, is showing top 20 regions. when I move it to 30, it shows top 30 regions.

But I need a small modification in this. Its like when I move the slider parameter control, I dont need the top 20 regions, I need the regions from top 11 to 20 instead of top 20. So the first top 10 regions needs to be neglected and regions from 11 to 20 needs to be displayed in the chart. Likewise when I move the slider to 30, i need to show regions from 21 to 30 based on the count of sold product.

Karthik

• ###### 2. Re: Need help for Top 10 Customers

Hi,

I have seen this article. This article is fine when we can select the range of values. What I need is a simple slider which has set size of 10 and once we slide in each step size, the data needs to be shows based on it. If we select 10 in slider, it needs to show chart for top 10 values (from 1 to 10) and when we slide it to 20, it needs to display only the next top 10 values (from 11 to 20) and not top 20 values.

Regards,

Karthik V

• ###### 3. Re: Need help for Top 10 Customers

Attach a packaged workbook showing how far you've gotten so far so we can build on that example.

• ###### 4. Re: Need help for Top 10 Customers

Hi Tom,

I have attached the packaged workbook and a screenshot for your reference.

The filter Agg(Top) in the workbook works perfectly based on my requirement. But instead of selecting a range in the filter Agg(Top), I need to have a slider(View by N Count in screenshot) containing pre specified set from 10 to 50 and selecting it I want the chart to load in the similar way the Agg(Top) filter does. If I select 10 in the slider(View by N Count in screenshot) the first 10 values needs to get displayed.alone. If I select 20, the next 10 values alone needs to get displayed and not all the 20 values from 1 to 20.

Thanks for your help in this.

Regards,

Karthik V

• ###### 5. Re: Need help for Top 10 Customers

Can anyone help me in this?

• ###### 6. Re: Need help for Top 10 Customers

Is this what you are looking for ?

Michel

• ###### 7. Re: Need help for Top 10 Customers

Hi Michael,

This is what I was looking for... I will try to learn how you did from the sample you have attached. If I have any problem in understanding can you please help me with that.

-KV