Creating a Heat Map Based on Start and End Times

pstrauss
pstrauss Member
edited March 2023 in Beast Mode

I have a data source that includes one row each for scheduled activities, with a column with the start date/time and end date/time (i.e. 2022-09-06T09:00:00 and 2022-09-06T13:00:00). What I need to produce is a heat map showing blocked out times in hour or half hour increments on a heat map, with the days of the week as the X axis and Time of Day as the Y axis.

I basically need to count up all of the occupied hour (or ideally half-hour) blocks between the start and end times and then build the chart based on those counts.

I've come across a solution for how this could be done in Excel by counting up the values that fall between time bands ( https://stackoverflow.com/questions/55700302/heatmap-between-start-and-end-times ) - but I can't figure out how I might achieve this in Domo. I'm okay solving this at either the ETL or Report/Beast mode function level.