12 Replies Latest reply on Nov 14, 2018 6:45 AM by Paul Wachtler

    LOD Calculation

    Rosyatul Hikmiya

      Hello All

       

      I wanna ask about my problem like my explanation below:

         

      IDOrder IDOrder Date
      1234511-Jan-18
      6789122-Jan-18
      1567833-Jan-18
      6541244-Jan-18
      1234555-Jan-18
      1234566-Jan-18
      1567877-Jan-18
      1567888-Feb-18
      1567899-Mar-18
      678911010-Jan-18
      678911111-Jan-18
      654121212-Jan-18
      654121313-Feb-18
      654121414-Mar-18
      12345151-Jan-18
      12345161-Jan-18
      12345171-Feb-18
      12345181-Feb-18
      12345191-Mar-18
      12345201-Mar-18
      12345211-Mar-18

       

      i wanna have result about how much id that have orders more than 2 in every month with range 3 months.

      please help me if u have solution.

       

      regards

       

      Rosy