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



      I would like to have the following output:

      Count of Order IDs:



      Count of Shipping Dates:



      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?




      Is there another solution.