Forum Discussion
Solved
Project Heatmap
Hi Community, I am looking for some help but haven't managed to find the right thread on the forum. I have been asked to create a Heatmap to show how many projects we have in any given Year, ...
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.