2 Replies Latest reply: Nov 19, 2012 2:43 PM by ahnet ceylan RSS

    Satisfy expression conditions

    ahnet ceylan
      =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

       

      Hello everyone,

      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

       

      How can I write an expression to satisfy my need from the each date view?

        • Re: Satisfy expression conditions
          ahnet ceylan

          It will be like Count({<ISTEK_ACISTARIHI2 = {"<=$(=Timestamp(Today() - 30, 'DD.MM.YYYY hh:mm:ss'))"},ISTEK_DURUM={'Açik'}>} ISTEK_ACISTARIHI2) but here expression always gets today as based date I want to make my dimension date as based date field

          Dimension:date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')

            • Re: Satisfy expression conditions
              ahnet ceylan

              Acik.png

              As you see above, Count(if(ISTEK_ACISTARIHI2 >=30,ISTEK_ACISTARIHI2, ISTEK_DURUM='Açık')) wtih this expression , ıt brings total amount 8 but ıt should bring zero since ISTEK_ACISTARIHI2 is not older than 30 days

               

              if ISTEK_ACISTARIHI2 older than 30 days and ISTEK_DURUM ='Açık' , ıt must count total rows both satisfies two conditions