Chart: How to set a data filter

[#1]

Hi all,

I have a bar chart where the X axis dimension is MonthNum (months from 1 to 12) taken from table A.

On this chart I'd like to count the CUSTOMER occurrences per month as reported in a different table B. In this table the month field is named MonthOpen.

I've set the expression for the bar chart as:

Count({<MonthOpen=MonthNum>} CUSTOMER)

but I get an error.

What's the right syntax to solve this problem?

Thank you.

[jpapador]

try this:

Count({$<MonthOpen=P(MonthNum)>} CUSTOMER)

Alternatively you could rename the MonthOpen field in the script to MonthNum and it would create a join and you would not need to use set analysis.

[maxgro · Accepted solution]

or perhaps also this 

Count(if(MonthOpen=MonthNum, CUSTOMER))

[#4]

Grazie, funziona perfettamente