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

    Count grouped by date



      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?