I would need to visualize the change in the status of the projects on a monthly basis.
In the database I have the following data in a table:
| id | EntityId | ProjectName | ProjectNumber | CurrentPhaseOldId | CurrentPhaseOld | CurrentPhaseNewId | CurrentPhaseNew | TrackDate | | 1 | 25 | Test | 321 | 0 | | 6 | Closed | 1.1.2023 10.10.10 | | 2 | 36 | Test | 321 | 6 | Closed | 7 | Archived | 1.1.2023 10.10.30 | | 3 | 36 | Test2 | 123 | 1 | Idea | 2 | Preparation | 3.3.2023 12.12.12 | | 4 | 36 | Test2 | 123 | 2 | Preparation | 9 | Rejection | 6.4.2023 12.33.23 | | 5 | 36 | Test3 | 333 | 2 | Preparation | 5 | Funding application | 5.5.2022 23.30.33 | | 6 | 36 | Test3 | 333 | 5 | Funding application | 3 | Execution | 25.5.2022 14.45.54 | | 7 | 36 | Test3 | 333 | 3 | Execution | 7 | Archived | 9.11.2022 10.14.54 |
|
| |
At first I thought that I would show the number of projects in a certain time interval in a bar chart, but could this be shown using, for example GANTT or similar visuals?
So if it were a bar chart, with the months on the x-axis and the number of projects on the y-axis and the status of the project at that time as an explanation, I would like to show in the visualization how many projects in the "execution" state there have been during that month. The year filter would be separately.
Thanks in advance if you can help me!
