Forum Discussion
Creating time series visualization from data snapshot
Since you want this by month you need a separate (disconnected) table with month names and codes. What should happen at the end of the year, by the way?
Then you create a measure that calculates for each stage how many projects were active in that month.
My idea was that the visualization keeps automatically updating to the current month. Projects get added on, shifted to other stages every so often and the idea is to get a historical progression of projects within stages till today/current month. About your comment on connecting month table to the table I have shown above, I am not sure how to connect the two tables with a common variable. I was thinking that the logic would be "go through each project entry in table 1, if stage x entry date is for e.g. Jan 2020, then no. of projects in Jan 2020 in stage x becomes +1. But I am not sure how to connect the month and project table to do that.