3 Replies Latest reply on Apr 3, 2017 12:58 PM by Shinichiro Murakami

    How to count dates with events?

    Thomas Human

      If I have the following:

       

      Order ID:     Shipping Date

      1                        1Jan17 4Jan17  5Jan 17

      2                        2Jan17

      3                        4Jan17

      4                        1Feb17

      e.t.c.

       

      I would like to have the following output:

      Count of Order IDs:

      4

       

      Count of Shipping Dates:

      6

       

      In order to do the following:

      On average, 1.5 shipping events per Order.

       

      I am having difficulty in correctly counting the shipping dates.

      Do I have to write a custom sql query, where I associate an actual event to each date, tied to the Order ID?

       

      OR

       

      Is there another solution.

       

      Thanks!