
1. Re: Calculate number of stores which meet the top category criteria
Shawn Wallwork Jun 14, 2015 8:35 AM (in response to Jesse yung)1 of 1 people found this helpful9.0 or 8.2

2. Re: Calculate number of stores which meet the top category criteria
Jesse yung Jun 14, 2015 8:46 AM (in response to Shawn Wallwork)have both. if LOD can solve it, would be great.

3. Re: Calculate number of stores which meet the top category criteria
Alexander Mou Jun 14, 2015 1:32 PM (in response to Jesse yung)1 of 1 people found this helpfulHere is my solution. No LOD is necessary.
https://public.tableau.com/views/CountbyTopProduce_AM/Sheet1?:embed=y&:showTabs=y&:display_count=yes

4. Re: Calculate number of stores which meet the top category criteria
Jesse yung Jun 15, 2015 7:50 AM (in response to Alexander Mou)hi Alexander, this looks great. However, I wasn't able to replicate your results. anything i missed out?

5. Re: Calculate number of stores which meet the top category criteria
Alexander Mou Jun 15, 2015 10:45 AM (in response to Jesse yung)1 of 1 people found this helpfulJesse,
In [Win Count]'s table calculations, there are two variables to be set:
 Rank U is set to compute using Produce
 Win Count is set to compute using Store
Then controldrag [Win Count] to filter shelf. Configure it by Special>NonNull Values
That's it.

6. Re: Calculate number of stores which meet the top category criteria
Alexander Mou Jun 15, 2015 1:23 PM (in response to Jesse yung)1 of 1 people found this helpfulAn alternative solution
Instead of using a Win Count filter, select menu Analysis>Stack Marks>Off
On Mon, Jun 15, 2015 at 7:51 AM, Jesse yung <

7. Re: Calculate number of stores which meet the top category criteria
Jesse yung Jun 16, 2015 7:08 AM (in response to Alexander Mou)thanks a lot! however, my main block is where to place 'rank'. it doesn't appear on any shelf.
This is my step by step:
i place store/produce/rank u to row shelf, set rank to calculate by produce. so far the ranking works ok.
then i drag win count to text mark to calculate by store. it doesn't work. it's showing 1 instead of 3.
anything wrong?

8. Re: Calculate number of stores which meet the top category criteria
Alexander Mou Jun 16, 2015 10:25 AM (in response to Jesse yung) 
9. Re: Calculate number of stores which meet the top category criteria
Jesse yung Jun 17, 2015 8:12 AM (in response to Alexander Mou)genius!