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

       

      istek.png

      my date dimension is :

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