Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.