Creating an "unassigned" row for gantt chart visualization
I'm working on a gantt chart visualization for resource assignments, and trying to add an "unassigned" bar to the chart for any time periods when a resource is not assigned to a project.
My dataset is generally structured as resource name, assignment name, start date, end date:
I've pulled in the domo dimensions calendar data set, and have been able to explode out these dates so that I have 1 row per resource, per assignment, per date. I also used this to create rows where Assignment Name = 'UNASSIGNED' if the resource has no assignment for a given date. I then tried grouping by resource name and date so that I had a column assignment type equal to either 'ASSIGNED' or 'UNASSIGNED' for each date, and that's where I got stuck:
I'm not sure how to take this and get the start and end date for each section of 'UNASSIGNED' to append to the original format so I can put it on the gantt chart. I thought I could do a group by but then realized that using that and the min/max functions would give me the very first date someone is unassigned and the very last date - but if there are multiple sections where they are unassigned (as above it would be 2/15/2022-2/28/2022 and then 5/1/2022 and on), it would not be correct.
Has anyone done something similar to this? Any tips or ideas? Is there an easier way to do this that I'm just missing?
- 10.7K All Categories
- 13 Getting Started in the Community
- 38 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 502 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board