Building a histogram or a stacked bar chart with date series data

Hi!
I have a datasource as excel file which I want to use to build a stacked bar chart. The data has a series of columns with week range as dates and hours worked per week against a project for a a particular person. Now I want to build a stacked bar against this data but seems like the dates dont allow me that option. If someone can please help me out with it would really appreciate it.
The data looks like :
Resource Name | Start | Finish | Units & Costs | Total | January 17, 2021 - January 23, 2021 | January 24, 2021 - January 30, 2021 | January 31, 2021 - February 6, 2021 | February 7, 2021 - February 13, 2021 | February 14, 2021 - February 20, 2021 | February 21, 2021 - February 27, 2021 | |||||||||||
xyx | 12-Nov-20 | 01-Jul-21 | Planned Units | 1,272h | 32h | 40h | 40h | 40h | 32h | 40h | |||||||||||
abc | 12-Nov-20 | 23-Aug-21 | Planned Units | 1,568h | 32h | 40h | 40h | 40h | 32h | 40h | |||||||||||
I want to build a stacked bar with hours by the week mentioned in the columns. The issue is those date ranges does not act as date and gives me an issue plotting the graph.
Help will be greatly appreciated.
Thanks
Comments
-
Your best bet is going to be to reformat your data to have a separate row for each week the resource works, like below. That way you can simply sum the "Planned Units" column and use the "Week Start" column to group by week.
Resource Name Week Start Planned Units xyx January 17, 2021 32 xyx January 24, 2021 40 1
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 106 SQL DataFlows
- 646 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 774 Beast Mode
- 75 App Studio
- 43 Variables
- 730 Automate
- 186 Apps
- 469 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 136 Manage
- 133 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive