Analyzing trend using Set Analysis

[#1]

Greetings

I am trying to analyze the trend.i.e A group of users score I want to analyze over a period of time.

I have requested for help in my previous posting

The solution provided  is working but I would like to clarify whether I should put condition in Set analysis also Need to set distinct.

Suppose if I choose 201307 where we have 95 users who had a score. Actual users are 103  because remaining 8 users never had any score , This users may or may not be participated in 201309 or 201308 etc. SInce I am analyzing only this 95 users I thought I will set COndition Score >0. Not sure we need DIstinct to be set.

If I need to set Condition Score >0 or DISTINCT where should I set in the second chart set analysis?

Thank you in advance.

[jagan]

Hi Ram,

You can use this expression instead of If, also if you have only one score for one month then there is no need for distinct, otherwise you need to use Distinct in expression.

=Count({<SCORE={'>0'}>}DISTINCT USER_ID)

Hope this helps you.

Regards,

Jagan.