Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to plot number of project started and, project completed comparison in a line chart for every month [And may be if possible number of open project for that month].
Below is the sample data.
| Project Id | Project Name | Start date | End date |
| 1 | Project 1 | 3/5/2017 | 4/5/2017 |
| 2 | Project 2 | 4/2/2017 | 4/25/2017 |
| 3 | Project 3 | 4/22/2017 | 5/15/2017 |
| 4 | Project 4 | 5/2/2017 | 5/21/2017 |
| 5 | Project 5 | 5/20/2017 | 5/30/2017 |
So number of project started in month of march were 1 and in month of April were 2 and month of May were 2.
Similarly number of project completed in month of march were 0 and in month of April were 2 and month of May were 3.
And optionally, if it can be plot in same graph, the number of open projects for that month in the above example in month of march there was 1 open project (1), in month of Apr there were 3 open project (1,2,3) and in month of may 3 open projects (3,4,5)
Expected graph.
