Forum Discussion
Project Heatmap
how many projects we have in any given Year, Month and Week.What's your definition of "week" and how does it relate to your definition of "month" ?
see attached
Hi lbendlin
Thank you for the tip.
I have put some sample data in the table below. For ease, I have put all the data into a single month.
| Project | Start Date | End Date |
| Project A | 01/01/2024 | 31/01/2024 |
| Project B | 10/01/2024 | 25/01/2024 |
| Project C | 05/01/2024 | 20/01/2024 |
In terms of the expected outcome, I have provided a straightforward view of what I hope to achieve: a calendar view, in this case January 2024, that shows in a heatmap style where we have the lowest and highest number of projects occuring simultaneously.
I hope this provides a bit more clarity to my ask.
Thank you,
Jamie
how many projects we have in any given Year, Month and Week.
What's your definition of "week" and how does it relate to your definition of "month" ?
see attached
Hi lbendlin
Thank you so much for sharing this. It has worked a treat.
In terms of the definitions of month, this is purely just the calendar month; Jan, Feb, Mar etc.
For weeks, this is Monday - Sunday, however given the level of detail we have been able to get from the solution you have provided, I think we have the granularity required and users can filter on the dates they need.Thank you again for all your help 🙂
Jamie
yeah, mixing weeks and months is ill advised at best and misleading at worst.