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

       

      istek.png

      my date dimension is :

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