6 Replies Latest reply on Aug 27, 2018 11:46 AM by Vijayalakshmi Pradeep

    Set of Events occurring sequentially

    Vijayalakshmi Pradeep

      Hi,

       

      I have table of recurring events happening week over week with week being a text and not date. There are stages for these events say 1-3 occurring sequentially. I have to count the change in each stages for each week.

      For example:

         

      MSG IDWeekNoStatusNo
      CAS-22333-N7R7C9WK11
      CAS-19984-Q4X5X0WK11
      CAS-19979-V1F1R6WK11
      CAS-01270-W4X0S7WK11
      CAS-01271-Z6M1K1WK11
      CAS-01272-N9M5S3WK11
      CAS-01273-V8V8W0WK11
      CAS-00968-Y6M4S8WK11
      CAS-11762-V6K2V7WK11
      CAS-15293-P6L1H8WK11
      CAS-22333-N7R7C9WK22
      CAS-19984-Q4X5X0WK22
      CAS-19979-V1F1R6WK22
      CAS-01270-W4X0S7WK22
      CAS-01271-Z6M1K1WK22
      CAS-01272-N9M5S3WK21
      CAS-01273-V8V8W0WK21
      CAS-00968-Y6M4S8WK21
      CAS-11762-V6K2V7WK21
      CAS-15293-P6L1H8WK21
      CAS-22333-N7R7C9WK33
      CAS-19984-Q4X5X0WK33
      CAS-19979-V1F1R6WK33
      CAS-01270-W4X0S7WK32
      CAS-01271-Z6M1K1WK32
      CAS-01272-N9M5S3WK32
      CAS-01273-V8V8W0WK32
      CAS-00968-Y6M4S8WK32
      CAS-11762-V6K2V7WK32
      CAS-15293-P6L1H8WK31