
1. Re: Control Chart Standard Deviation Analysis  give me the top X that break limits
Jim Wahl Jan 17, 2014 9:19 AM (in response to Lynn Edwards)2 of 2 people found this helpfulDo you have the product rows sorted by in the order you want to filter?
If you do, you might be able to add a discrete calculated field, INDEX(), to the left of the Product dimension on the Rows shelf. This will essentially add a row number. You can then drag a copy (ctrlrightclick) to the filter shelf and set it to show just the top 10.
RANK() introduced in Tableau 8.1 is another option with a little more flexibility.
If you don'tand need to sort based on a table calculationthen you won't be able to specify the Product sort order using the table calc, but you can add a discrete copy of the table calc left of the Product dimension to force the sort order. And then add index().
Good luck!

2. Re: Control Chart Standard Deviation Analysis  give me the top X that break limits
Jonathan Drummey Jan 17, 2014 9:37 AM (in response to Lynn Edwards)I set up a version of what Jim described, in this case the control limits are set week by week, you could change those within the nested table calculation.

top N over stdev.twbx 1.9 MB
