Lisa,

What happens when Location is placed on Rows and Program is placed on Columns with a Count(customer id) in the view?  I have attached a Superstore sample view of something like this.  Just wondering whty this does not work?  If there is something about the data throwing off the expected results?

The example is done in Tableau 10.2. 

If you have a bit of sample data to show the issues that you are running into or worse case, a picture.  That would help a lot. 

Patrick 

Hi Lisa - And hi Patrick -

I have read your problem statement a couple of times and have some questions - You created Sets of programs - I'm a little confused - what gets grouped together to form a Set - and are you placing the Sets or Programs on your column shelf to form a grid? are the Sets unique - no overlapping element. Can a customer purchase from more than one program (set) and can they shop at different locations?

Jim

good - Yes that is getting closer to the answer -

If I have this straight each location is the only unique part - customer (visits) are multiple and each customer can buy multiple programs within a visit

So the business question is location dependent and you have 3 other variables - customers - visits - programs

Not certain what you are trying to show but you can think about LOD expressions to isolate Locations or looking from the program perspective to identify which locations were the most successful -

OK you are on a good path

Jim

Hi -

I'm no Statistician so don't let me lead you astray -

I would suggest a little learning experiment

set up the vis just like you have above with Programs (apples etc) for columns and location for row then just put in Visits and get the sum of the visits

Then try something like {Fixed [location]: sum([visits] )}

Then try to do some calculation to determine the % of the totals that is represented by each cell and see hoe the LOD expression can play into that calculation

You might also want 1 more {fixed:sum(visits)}

I am an old excel guy and I needed to do something like that to understand how to get to the answers I wanted

Let me know how it goes

Jim

After you create your grid and lod calculations play with time filters and

see what effect they have

Enjoy

Jim

On Mar 6, 2017 5:39 PM, "Lisa Connelly" <tableaucommunity@tableau.com>