Expression for Count Distinct All Prior Periods

[#1]

count(distinct {$<Month={"<={'Apr'}"}>} Event)

what would the proper syntax be to count all distinct events before April. The expression above is returning 0.

[Sokkorn]

Hi Jonh,

You may try

count({$<Month={"<={'Apr'}"}>} distinct Event)

Regards,

Sokkorn

[MK_QSL]

Count(Distinct {<Month = {"<={'April'}"}>}Event)

If you want to consider for only current year, use as below

Count(Distinct {<Month = {"<={'April'}"}, Year = {'2014'}>}Event)

[#4]

Tried all of the expressions listed above and I get a 0 result back, which I know is not the case. Could there be something erroneous with specifying less than 'Apr'? 

[vgutkovsky · Accepted solution]

You can't compare "Apr" as a numeric value. Try this: count({<Month={"<=4"}>} distinct Event)

Regards,

Vlad