Set Analysis Query - Using Data Island on Table

[Dayna]

Hi All,

I hope I'm explaining myself correctly here. I have an application where I'd like to show the count of ProjectElement.Id where the created month (ProjectElement.MonthNameCreated) equals my master calendar month (Cal.MonthName), and the selected category (Product.Category.Name) equals my master category selector (Category.CategoryName).

I'm going to be extending this out soon to also look at the completed month, hence my use of master calendar here.

What I've got so far, is the set analysis on a table for the monthname, but it doesn't pay attention to the dimension and sums across all the values for the month. What I would expect for the month of January is:

Month	Category	Value
January 2017	Baby	7
January 2017	Facial	25
January 2017	Fem	1
January 2017	Household	13
January 2017	Medical	0
January 2017	Moist Toilet Tissue	1
January 2017	Other	0
January 2017	Personal Care	1
January 2017	Pet Care	0

But instead, unless I select the individual month, the table shows 62.

Ideally, I'd like to have this for all months, so this should show February, March, etc..

I think the set analysis needs to be something like:

count({<Element.Name = {'Launch'}, ProjectElement.MonthNameCreated= (Cal.MonthName), Product.Category.Name= (Category.CategoryName)>} DISTINCT ProjectElement.Id)

... but this doesn't return any results.

Can someone please help me!

Kind Regards,

Dayna

[sunny_talwar · Accepted solution]

Set analysis won't work here... may be try with if statement

Count({<Element.Name = {'Launch'}>} DISTINCT If(ProjectElement.MonthNameCreated = Cal.MonthName, ProjectElement.Id))

[Dayna]

Looks good, thanks Sunny!