Count number of dates that happen before the given date
I have a list of events and I want to be able to give each event an event number based on the date it occurs in the year, so if there are no dates before it in the year then it will be event 1 when the next year rolls around I'd want it to start over at 1 and begin numbering the events again. Here is my initial expression for the calculated dimension:
Re: Count number of dates that happen before the given date
Yes, that's possible. You can concatenate the fields to autonumber the combination of the fields or for the combination that should determine the counter. For example autonumber(EventID&EventCategory, Year) or autonumber(EventtID, Year&EventCategory).