Forum Discussion
SJ25
Resolver I
5 years agoCounting Projects started & finished each month
Hello All,
I'm trying to get a simple count of how many projects got started in each motnh and how many got completed. I have the start & end date for all projects, sample below:
| Start Date | End Date |
| 2/12/2020 | 3/15/2020 |
| 3/10/2020 | 4/10/2020 |
| 5/12/2020 | 8/24/2020 |
Here's the output I'm looking for:
| Months | Started | Completed |
Jan | ||
| Feb | 1 | |
| March | 1 | 1 |
| April | 1 | |
| May | 1 | |
| June | ||
July | ||
| August | 1 |
I've created an independent table with all months in it, but I think what's causing an issue for me is when I establish a relationship to my main table containing the dates.
Any help would be much appreciated
2 Replies
- amitchandak
Super User
- SJ25
Resolver I
Thanks a ton! Worked great