2 Replies Latest reply: Feb 3, 2013 1:10 PM by John Chatlani RSS

    set analysis time based

    John Chatlani

      Hello -

       

      I have a table with two columns

      date
      author
      2/1/2011john
      2/1/2011jerry
      2/1/2011jack
      2/8/2011john
      2/8/2011jack
      2/8/2011vijay

      and I would like to use set analysis to identify the new author(s) in some timeframe pop out (if the timeframe is 1 week in this case, vijay will pop out).

       

      I have tried an expression as follows but it isn't quite working:

       

      concat(<date/={"<=$(=timestamp(now()-7))"}>} author,',')

       

      Here my timeframe is in the last 7 days.

      this effectively produces jack, john and vijay instead of vijay alone.

       

      Any help is appreciated.