count users

[#1]

Hi

I want to count users per monthyear and I am using an expression in a straight table to do so.

The expression is:

  =Count(DISTINCT userID({<monthyear = {'January 2013'}>} userID))

Obviously there is something wrong with this expression, can someone help me correct it?

Thanks!

[Nicole-Smith · Accepted solution]

=Count({<monthyear = {'January 2013'}>} distinct userID)

[Aurelien_Martinez]

Hi,

Try this :

=Count(DISTINCT {<monthyear = {'January 2013'}>} userID)

Aurélien

[MK_QSL]

Create a straight table

Dimension = MonthYear

Expression

= Count(Distinct userID)

[#5]

thanks