Hi - first, thanks to all for the consistent great advice!.
Now, the big Q...
I'm trying to create a report that captures how many projects were opened, closed and canceled in a given month, grouped by each month in the year.
Fields I have include start date, end date and status.
I can create a report that will group each month by either start date or end date, but my concern is that the counts in each grouping won't be accurate. For example, if I have a group based on 'start date' that will include only months where a new project was 'started'. Does that make sense?
What I'd ideally like to do is have the report grouped by month, but based on values that aren't specific to data. Just a list of the 12 months, with my data grouped within there.
Any thoughts??
Many thanks!
Now, the big Q...
I'm trying to create a report that captures how many projects were opened, closed and canceled in a given month, grouped by each month in the year.
Fields I have include start date, end date and status.
I can create a report that will group each month by either start date or end date, but my concern is that the counts in each grouping won't be accurate. For example, if I have a group based on 'start date' that will include only months where a new project was 'started'. Does that make sense?
What I'd ideally like to do is have the report grouped by month, but based on values that aren't specific to data. Just a list of the 12 months, with my data grouped within there.
Any thoughts??
Many thanks!