0 Replies Latest reply: Nov 22, 2012 6:55 AM by ahnet ceylan RSS

    expression historic data

    ahnet ceylan

      Hello ,

      I would like to show historic data in chart

      Let me explain in example;

      In my chart I have one dimension and two expressions

      My dimension is calculated and its formaula is date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')

      One of my expression is that it considers two fields (ISTEK_DURUM)(this is request statu such as open,closed) and (ISTEK_ACISTARIHI2)(this is creation date of request)

      With this expression I want to see request that ISTEK_DURUM=''Açık' and creation time older than 30 days before (my dimension displays each start day of week)

       

      I can calculate the expression based on today with this formula

      =count((if(date(today())-date(ISTEK_ACISTARIHI2,'DD.MM.YYYY')>=30 and ISTEK_DURUM='Açık',1)))

       

      but for each week ı can not calculate it means based on week ,shown in graph, I cannot get data older than days before that week

      what ı want is that

      its not working count((if(date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')-date(ISTEK_ACISTARIHI2,'DD.MM.YYYY')>=30 and ISTEK_DURUM='Açık',1)))

       

      You can see my qw in turuncu hat istekler tab