3 Replies Latest reply: Sep 17, 2012 9:29 AM by Jose Tos RSS

    Count grouped by date

      Hi,

       

      I'm trying to count number of "HayRolling" activities over a specific period, for instance per week.

       

      ActivityDateTimeStampYearWeek Number
      HayRolling14.09.2012 12:04:382012371
      HorsePlay14.09.2012 12:00:082012371
      HayRolling13.09.2012 15:35:172012372
      HayRolling14.09.2012 12:16:002012371

       

       

      So the HayRolling activities should be group and display 4 in this example. Currently the activities are grouped only if the timestamp is identical, as in the 3rd row. My expression:

       

      =Count({$<Activity={"HayRolling"}>} [Year]&[Week])
      

       

       

      How can I achieve this please?