Count grouped by date

[#1]

Hi,

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

Activity	DateTimeStamp	Year	Week	Number
HayRolling	14.09.2012 12:04:38	2012	37	1
HorsePlay	14.09.2012 12:00:08	2012	37	1
HayRolling	13.09.2012 15:35:17	2012	37	2
HayRolling	14.09.2012 12:16:00	2012	37	1

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?

[chematos · Accepted solution]

Try this:

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

or may be with TOTAL:

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

hope this helps

[#3]

Thanks, José!

Can't spot any differences with or without TOTAL.

[chematos]

Yes, should be the first one but just in case....

You´re welcome