1 Reply Latest reply: Jul 5, 2011 10:14 AM by Annika Palm RSS

    expression within a set analysis

    Annika Palm

      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.