Forum Discussion
Count of Active Projects between two dates
My apologies if this exists already, i have been searching and found similar, but nothing that has worked when tested out, nor seems to fit this need. I have a table with a Project ID, Start Date...
I am trying to do something similar I think...I can have projects that can span multiple years and I want a count of each project that occurred in each year...but stops at the current year...for example, the projects below would produce the counts at the bottom. In each project is a LOB and so would like to be able to show the number of projects by LOB and year....I can add the LOB if if I can figure how to produce the counts by year...this should do it for as many years as the data contains (mostly only has about 3 years and not a large quantity)
| Start | End |
| 1/22/2022 | 5/2/2022 |
| 11/1/2021 | 6/1/2022 |
| 10/1/2021 | 12/1/2021 |
| 12/2/2020 | 4/3/2022 |
| 4/2/2020 | no date |
| 2020 | 2 |
| 2021 | 4 |
| 2022 | 4 |
So if I can make this a table and/or a chart (like a bar chart) it is what's needed...
How did you arrive at the answers of 2,4 and 4? Please give a proper explanation.