Creating a Heat Map Based on Start and End Times
pstrauss
Member
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 (
) - 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.0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 561 Beast Mode
- 8 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive