Heat Map Gantt/Dates?

[cbaqir]

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.

thanks!

Cassandra

[Anonymous]

please can you post sample data cassandra , so can help

[cbaqir]

Sample Data Attached

[Anonymous]

Hi,

Thanks,will update once solution is done.

[cbaqir]

Any luck?

[Anonymous]

Hi Cassandra,

no luck as yet

Regards

Neetha

[cbaqir]

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.

[cbaqir]

Still looking for some help with this from someone.