0 Replies Latest reply: Nov 20, 2012 6:14 AM by ahnet ceylan RSS

    create an expression

    ahnet ceylan

      İn my qw ,

      I wanto to create second expression

      İt must include ISTEK_DURUM='Açık' and ISTEK_AÇISTARIHI2 older than 30 days before selected ISTEK_ACISTARIHI2

       

      when I select ISTEK_DURUM as 'Açık'  and date older than 30 days from ISTEK_ACISTARIHI2 it must count affected rows

       

      =date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')ISTEK_DURUM
      19.11.2012AçıkDimension=date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')
      12.11.2012Açık
      05.11.2012Kapalı
      29.10.2012Açık
      22.10.2012Kapalı
      15.10.2012Açık
      08.10.2012Açık
      01.10.2012Açık

       

      I can explain in sample.

      In list above I want to display in chart and my dimension as you see.

      but my need is that When I looked in 05.11.2012 date I want to display 30 days and older before 05.11.2012  date and ISTEK_DURUM="Açık"

      For each date I would like to see this information

       

      For instance from the wiew of 19.11.2012 how many request satisfy my need

      these three rows satsify my need

      15.10.2012Açık
      08.10.2012Açık
      01.10.2012Açık