2 Replies Latest reply on Jun 23, 2016 7:24 AM by nick.altmann

    Max of daily date count by month

    nick.altmann

      Given a list of dates, how would I find the maximum of the count of dates for any single date by month?

       

      I know how to do count of dates by date or month, but I don't know how to do the max of a daily count of dates by month.

       

       

      Example data:

       

      Input Data - note that dates repeat

      Date
      2016-06-01
      2016-06-20
      2016-06-20
      2016-07-04
      2016-07-05
      2016-07-06
      2016-08-01

       

      Desired Output - formatting is not important

      MonthMax Daily Count
      2016-062
      2016-071
      2016-081