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

    expression for 2 years

    ahnet ceylan

      Hello ,

      I have data for 2 years ı would like to create chart based on weekly

      For each week I want to see the data includes specific condition

      These conditions are that for each week how many requests there are statu is 'Open' and

      other condition is that for each week how many counts there are statu is open older than 30 days or much

      for example today : 21.11.2012

      I have 200 request 100 of 200 statu is open .

      and 60 of 100 statu is open longer than 30 days

       

      next week(28.11.2012) ıt may be 80 counts is open

      accoridng to this week maybe 50 of 80 statu is still open longer than 30 days

       

      How can I solve this.

       

      Thanks