4 Replies Latest reply: Nov 19, 2012 4:44 AM by ali ceyli RSS

    Expression about date

    ali ceyli

      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 :