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.