expression within a set analysis

[Anonymous]

Hi!

I want to count number of persons that's got one or more points over the last 30 days.

I figured it would be something like this;

count({$<Name= {"=sum({$<Date={">=$(=today()-30) <=$(=today())"}>} Points)>0"} >} distinct Name)

But it doesn't work.

I'm I on the right track or is it done in another way?

Thanks.

//A.

[Anonymous · Accepted solution]

I made it harder than it was. Here's the sollution:

count({$<Date={">=$(=date(today()-30)) <=$(=date(today()))"} >} distinct Name)

//A.