4 Replies Latest reply: Nov 19, 2012 4:44 AM by ahnet ceylan RSS

    Expression about date

    ahnet ceylan

      Hello everyone ,

      In my chart ı have two expressions one of them

      count(IF(ISTEK_DURUM='Açık',ISTEK_DURUM))  (requests' statu : Open)

      second expression

      =Count({<ISTEK_ACISTARIHI2 = {"<=$(=Timestamp(Today() - 30, 'DD.MM.YYYY hh:mm:ss'))"},ISTEK_DURUM={'Açık'}>} ISTEK_ACISTARIHI2)

      requests' statu open over 30 days


      The problem is with second expression. above formula is working but business side want to see quantityof requests' statu open over 30 days for each week



      my date dimension is :