I have a requirement to show the following type of heat map based on overlapping dates of tasks.
I've found a couple of heat map videos but those are using expressions such as Sum(profit) and not dates. Any idea on how I could achieve the data below? Each TASK has a TASK_START_DATE and a TASK_END_DATE.
So... maybe I need something like if a.start_date <= b.end_date AND b.start_date < a.end_date then 1 else 0? I'm not sure how I would define what a or b is though... it could be across several filters.