2 Replies Latest reply: Jan 13, 2010 10:24 AM by Max Piilonen RSS

    Set analysis - show only last 12 weeks data

      Hi!

      I'm a newbie to Set analysis but is finding it very hepful, specially when designing dashboards where I don't want the users to make selections.

      I want one of my charts in the dashboard to only show the trends for the last 12 weeks. But my set expression doesn't seem to work for me.. I need some of your expert help :)

      My date format in the application is YYYYMMDD as you see below. This expression gives back current selections instead of giving only dates larger than the start of week twelve weeks ago.

      Cheers,

      Max

       

       

       

      sum

      ( {$< Date = {">=$(=date(#weekstart(Today(),-12),'YYYYMMDD'))"} >} StdTime)