2 Replies Latest reply on May 23, 2016 9:32 AM by Rajesh Doma

    How to Calculate Order Instance of Customer?

    Rajesh Doma


      As shown in below pic,I am looking for help on Calculating the Order Instance(Highlighted in red) of each Order of a Customer based on Order Date.

      I am specifically looking if It can be achieved using LOD Expression but I am Ok with alternative Approach too.

      I am to do some analysis like Average Time take to place Nth(E.g 6th) Order,Revenue from all Nth Order Sales etc.

      Please find attached SuperStore twbx

      Order Example.png