Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Thanks, José!
Can't spot any differences with or without TOTAL.
Yes, should be the first one but just in case....
You´re welcome