Count Set Analysis - Using User, Period and Multiple Field values

[BillCarlson]

Hello,

I am working through a tough one that I can't figure out. I have an example dataset attached. I am looking to 1st look into the Color/Vehicle field if Red exists then either Car, Bike or Board then the value would be 1.  I can get that part, but where I am having an issue is keeping the Month dynamic, so if I select any month range that does not include Jan I would get a zero value count or just a value of 1 for just Jan.

Thanks for your help,

Bill

User	Month	Color/Vehicle
Paul	Jan	Red
Mary	Jan	Red
Steve	Jan	Blue
Jan	Jan	Purple
Bill	Jan	Green
John	Jan	Red
Mary	Jan	Yellow
Paul	Jan	Bike
Mary	Jan	Car
Steve	Jan	Car
Jan	Jan	Car
Bill	Jan	Bike
John	Jan	Board
Mary	Jan	Surf
Paul	Jan	Car
Mary	Jan	Board
Steve	Jan	Bike
Jan	Jan	Bike
Bill	Jan	Bike
John	Jan	Bike
Mary	Jan	Board
Paul	Feb	Red
Mary	Feb	Red
Steve	Feb	Blue
Jan	Feb	Purple
Bill	Feb	Green
John	Feb	Red
Mary	Feb	Yellow
Paul	Feb	Bike
Mary	Feb	Car
Steve	Feb	Car
Jan	Feb	Car
Bill	Feb	Bike
John	Feb	Board
Mary	Feb	Surf
Paul	Feb	Car
Mary	Feb	Board
Steve	Feb	Bike
Jan	Feb	Bike
Bill	Feb	Bike
John	Feb	Bike
Mary	Feb	Board

[chrismarlow]

Hi,

I am not sure I fully understand what you are asking for, but how about the following;

avg({<[Color/Vehicle]={'Red'}>}1)*avg({<[Color/Vehicle]={'Car','Bike','Board'}>}1)

So;

Cheers,

Chris.