2 Replies Latest reply: Nov 19, 2012 7:51 AM by ahnet ceylan RSS

    Set analysis for an expression

    ahnet ceylan

      Hello

      I wanna write a set analysis for count request like

      requests' statu = "Acik"

      and its statu 'Acik' older than 30 days ago my date field ISTEK_ACISTARIHI2  format  is "DD.MM.YYYY hh:mm:ss"

       

      but for each week I would like to see   total count of request's statu 'Acik' and older than 30 days ago

      my date dimension is =date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')

       

      for example 14.05.2012 total count  (statu 'Acik' older than 30 days ago  )

      21.05.2012 total count  (statu 'Acik' older than 30 days ago  )