2 Replies Latest reply on Dec 4, 2018 11:44 PM by Mahfooj Khan

    How to get

    Calvin Pinto

      Hi All,

               I want to show the Particular order id of the earliest time instead of showing all other order ID, can someone help me out with this requirement. I have appended sample of the requirement as well the sample workbook.

       

          

      Day of Create_ActualActivityGor Id24 hour
      04-12-2018pickup_failedGRH833825121:44
      04-12-2018pickup_failedGRH4993470721:44
      04-12-2018pickup_scheduledGRH1130688014:37
      04-12-2018pickup_scheduledGRH1680217714:37
      04-12-2018pickup_scheduledGRH3575555117:44
      04-12-2018pickup_scheduledGRH4810619513:47
      04-12-2018pickup_scheduledGRH5422216213:39
      04-12-2018pickup_scheduledGRH8875072310:27
      04-12-2018pickup_scheduledGRH9313491914:38
      03-12-2018deliveredGRH89668816:39
      03-12-2018deliveredGRH224953616:45
      03-12-2018deliveredGRH4960232416:41
      03-12-2018deliveredGRH7557990216:24
      03-12-2018deliveredGRH7802696616:36
      03-12-2018deliveredGRH8994187416:43
      03-12-2018dispatchedGRH89668814:19
      03-12-2018dispatchedGRH224953609:36
      03-12-2018dispatchedGRH4960232409:35
      03-12-2018dispatchedGRH7557990214:52

       

      Regards,

      Calvin

        • 1. Re: How to get
          Ombir Rathee

          Could be please illustrate your expected results from this dataset ?

          • 2. Re: How to get
            Mahfooj Khan

            Hi,

             

            Do you want to fetch the Order ID based on Creation date per Activity or only based on Creation date?

             

            Below calculation will fetch Order ID based on Creation date per Activity. Put this field in filter shelf and select "True"

             

            [24 Hour]={FIXED [Day of Create Actual],[Activity]:MIN([24 Hour])}

            If you wants to fetch  Order ID based on Date of Creation then modify the above logic and exclude the [Activity] field from expression.

             

            [24 Hour]={FIXED [Day of Create Actual]:MIN([24 Hour])}

            Likewise if you wants to fetch the earliest one then exclude the [Day of Create Actual].

            [24 Hour]={MIN([24 Hour])}

            Choose whichever applicable in your case.

             

            Let us know if this help.

             

            Mahfooj