3 Replies Latest reply: Jul 23, 2014 5:48 AM by Marcus Malinow RSS

    Site utilization Continuous Week count

    JATIN KOLHE

      Hi All,

       

      The scenario is that we have several sites which gets utilized and when  the current value goes above threshold value ,we get alert.

      I have to find out for each site , the count of weeks starting from the current week when  it was continuously alert status without break of alert in any week.

      Also data for a site comes into the table only when it has been alerted.

      eg:

      Site A was alerted for July 3rd week, July 2nd week but not on July 1 st week then count should be 2.

      Site B was alerted for July 3rd week, July 2nd week, July 1 st week,June 4th week ,June 3rd week but not on June 2nd week ,again alert came on june 1st week still then count should be 5.

       

      Regards,

       

      Jatin Kolhe.