How do I create a trend chart ?

[#1]

Greetings

I am trying to analyze the trends. My client launched a new products where each user accumulate points every month  when they participate in some activities.

When they launch the product in Mid July 2013,. they had 103 Members and gradually the membership increased every month.

Now I want to analyze the first 103  members point accumulating trends on monthly basis. how do I create a chart?

I have created the chart as follows but looks like I am wrong.

Chart 1,

Dimension :MONTH_CD

Expression :COUNT(USER_ID)

Chart 2:

Dimension :MONTH_CD

Expression :SUM(SCORE)

When I select Month 201307, then I am unable to see 201308,201309 etc for the users who participated in 201307. How do I analyze the trend for selective users?

Thank you

[#2]

swuehl

Thank you for the reply. I think your suggestion is working.

I have added sample application and data files in my original thread.

Thank you once again.

[#3]

instead you can use:

getfieldselections ( FieldName [, ValueSep [, MaxValues]])

Returns a string with the current selections in a field.

ValueSep is the separator to be put between field values. The default is ', '.

Maxvalues is the maximum number of field values to be individually listed. When a larger number of values is selected the format 'x of y values' will be used instead. The default is 6.

Examples

getfieldselections ( Year )

getfieldselections ( Year, '; ' )

getfieldselections ( Year, '; ' , 10 )

[#4]

Hi Kumar

This does not work

My expression as follows

=sum({<USER_ID = p({<MONTH_CD={$(vMonth)}>})>}SCORE)

My Variable

vMonth==GetFieldSelections(MONTH_CD)

I have uploaded my original files in main thread. If you find time May I request you to look into the files?

Thanks anyway